Devart Forums

How to return messages/values printed by stored procedure?
I using sp_help_revlogin stored procedure at MSSQL 2008r2 that create server logins export script, but using print output.

How to grab this printed output with MSDAC (and save to stringlist or etc...)?

Thanks!

Problem solved!

I created stringlist and new procedore.
Before executing I create stringlist and redirecting OnInfoMessage on connection to my procedure. Procedure putting message to stringlist. Then execute stored procedure and saving stringlist to disk, assigning it to memo... and then destroying stringlist and unasigning OnInfoMessage.

It is correct, PRINT statements can be handled in the TMSConnection.OnInfoMessage event handler.