June 23, 2009 at 8:20 am
Hello I want to monitor the SQL log for specific events that will result in notification. I know it puts that sql holds the data in text files. But is there anywhere that that the data is held in sql so I can create an alert.
June 23, 2009 at 10:22 am
You can use xp_readerrorlog to periodically scan the error logs for the events you are interested in. This can be done by reading the content in to a temporary, staging or table variable and filtering out the events you are interested in. You can keep track of these events based off the LogDate column.
June 23, 2009 at 10:24 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply