View output of 'print' statements of StoredProcedures

[medzoom]

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

[AndreyZ]

Unfortunately, UniDAC doesn't have the functionality that allows obtaining the messages of the PRINT statements. For the time being, such functionality is available only in SDAC (using the OnInfoMessage event handler of the TMSConnection component).
We already have such request at our UserVoice page. You can vote for it here: http://devart.uservoice.com/forums/1046 ... connection. Suggestions with many votes will be implemented faster.

[medzoom]

mercy for the answer!

medzoom

[AndreyZ]

If you have any other questions about UniDAC, please contact us.