Receiving SqlServer messages

From: Ruggero Rossi (ruggero.maria.rossi_at_libero.it)
Date: 04/30/04

  • Next message: nazeer Jr.: "RE: SQL Server connection" 
    Date: Fri, 30 Apr 2004 12:23:42 +0200

    Hi all,
    I have a stored procedure in a SqlServer 2000 database, which takes a long
    time to complete.
    I added some messages in the stored to trace the execution, using
      print @message

    Running the sp in QueryAnalizer, I can see the messages; is it possible to
    obtain the same messages using a delphi application?
    Do I have to use 'raiserror' ?

    I use D7 and standard ado components.

    Thanks in advance.

    Ruggero

    PS: excuse my poor english.

  • Next message: nazeer Jr.: "RE: SQL Server connection"

    Relevant Pages

    • stored procedure not found !! ???
      ... My database had been appended from another sqlserver 2000. ... have problems to call a stored procedure. ... First a command object ist created, ...
      (microsoft.public.sqlserver)
    • Re: OleDb vs. Sql Interoperability
      ... if I were to choose to switch between Sql and OleDb, ... interact with database data. ... database, building the call (query, Stored Procedure, Stored Procedure ... SqlServer to some other database backend, I can just change my DB ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: OleDb vs. Sql Interoperability
      ... if I were to choose to switch between Sql and OleDb, ... interact with database data. ... database, building the call (query, Stored Procedure, Stored Procedure ... SqlServer to some other database backend, I can just change my DB class, ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: OleDb vs. Sql Interoperability
      ... if I were to choose to switch between Sql and OleDb, ... interact with database data. ... database, building the call (query, Stored Procedure, Stored Procedure ... SqlServer to some other database backend, I can just change my DB ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: SqlAdapter not returning value
      ... DataTable RefundValueDT = new DataTable; ... the stored procedure should ideally return one column ... queries to the database fails and we have to restart the ... >> (the client, not the sqlserver) ...
      (microsoft.public.dotnet.languages.csharp)