I execute the below statement in management Studio:
EXEC [master].[dbo].[xp_ss_list] @filename = @ArchivePathAndFilename,@debug = 0
and here is the message in prints:
xp_ss_list completed successfully.
dummyFullPRIMARYdummyC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\dummy.mdf
dummyFullPRIMARYdummy1C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\dummy1.ndf
dummyFullNULLdummy_logC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\dummy_log.ldf
dummyFullNULLdummy1_logC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\dummy1_log.ldf
(0 row(s) affected)
----------------------
what exactly its doing is ..... i create a backup file using this tool(idera), and i am trying to list the contents of the backup file using the same tools's custom extended procedures.
My question now would be how to capture these messages printed into a table