Post reply

Capture Messages

  • April 29, 2010 at 6:51 am

    #156913

    lets say I have a SQL stored procedure that use print statements or use TIME ON option to record duration. In query analyser the results of the print statements they would appear in the message

    tab. How can I capture these messages to review later.

  • April 29, 2010 at 8:47 am

    #1159765

    If you don't need to see the messages at the time the proc is run, Insert them into some sort of log table. If you do need to see the messages, Print them and then Insert them or vice-versa.

    We created our own DBA only database that contains all sorts of user tables for monitoring things like disk space, blocked queries, and even logging emails sent out by SSIS packages or Procs. Managed correctly, a database like this can be all kinds of helpful. Managed badly and it's just another source of bloated, useless data.

    Example A

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply