Home Forums SQL Server 2005 T-SQL (SS2K5) insert printed messages from message tab into a table!!!! RE: insert printed messages from message tab into a table!!!!

  • 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