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!
			
									
									
						Returning values printed by statement
Re: Returning values printed by statement
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.
			
									
									
						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.
- 
				AndreyZ
 
Re: Returning values printed by statement
It is correct, PRINT statements can be handled in the TMSConnection.OnInfoMessage event handler.