Post reply

Catching the alert message in a table

  • December 9, 2004 at 12:39 pm

    #361709

    Does anbody know how can a message from an alert be caught and stored? What I would like to do is to be able to store in a table the date/time and the message from an alert any time it occurres.

    Thanks,

    Gabriela

  • December 13, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • December 13, 2004 at 10:28 am

    #533589

    I was looking for the same long time ago, but didn't find solution. I use instead of this query to SQL Server log for alerts messages (they should be logged):

    EXEC sp_readerrorlog 1, 'C:\MSSQL\LOGS\SQLlog.txt', 1, 'error'

    where 'C:\MSSQL\LOGS\SQLlog.txt' - is location of your SQL serever error log, 'error' - is search string for you allert.

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

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