View output of 'print' statements of StoredProcedures
Posted: Sun 14 Apr 2013 10:22
I am using TUniStoredProc for reading the results (even multiple resultssets) successfully of an executed StoredProcedure on an MSSQL 2008.
But I dont get it work, to read the "usual output of the sql-server / for example the print-statements of the StoredProcedure"?
I put some Print-Statements in the StoredProcedure on the sql-server and it would be nice to read via DELPHI also this information.
[code]
sql1.StoredProcName := 'sp_read_testtable';
sql1.SQL.Clear;
sql1.PrepareSQL;
sql1.ExecProc;
....
[/code]
I am using UniDAC 4.3.8 on Delphi 2007 /Win32
Does anyone know a workaround?
best regards
medzoom
But I dont get it work, to read the "usual output of the sql-server / for example the print-statements of the StoredProcedure"?
I put some Print-Statements in the StoredProcedure on the sql-server and it would be nice to read via DELPHI also this information.
[code]
sql1.StoredProcName := 'sp_read_testtable';
sql1.SQL.Clear;
sql1.PrepareSQL;
sql1.ExecProc;
....
[/code]
I am using UniDAC 4.3.8 on Delphi 2007 /Win32
Does anyone know a workaround?
best regards
medzoom