I'm using ADO.NET to call a stored procedure that runs the "BACKUP" command
on selected databases. Is there any way I can capture the text output of the
stored proc and return it to ADO.NET for displaying in my application?
When I run the stored procedure from SQL Query yzer, I get an output (in
the messages tab) like:
Processed 1496 pages for database 'OldBO', file 'TB_BackOffice_Data' on file
Processed 1 pages for database 'OldBO', file 'TB_BackOffice_Log' on file 1.
BACKUP DATABASE successfully processed 1497 pages in 1.909 seconds (6.420
Processed 120 pages for database 'Profile', file 'Profile_Data' ...