March 22, 2012 at 10:04 am
I am doing some housecleaning on a database whose structure was upgrade recently. Now, there are a bunch of Procedures and Tables which need to be dropped. My strategy is to rename all the procedures and tables and then enable the alert system to send out emails if there are any calls to the procedures or tables that I have renamed. There is a "SQL Server Event Alert" Severity "011 - Specified Database Object Not Found" which I have enabled on the said database.
However, when I try to access a table which does not exist....I do see the error in SSMS query analyzer but, fail to get the alert invoked. I don't see any occurrence of said error in the Error Log either. Could some one please help me troubleshoot this issue?
I already have Mail Profile enabled in the SQL Server Agent Properties. I am not noticing the alert being triggered at all.
Thanks in advance
March 22, 2012 at 11:47 am
anish_ns (3/22/2012)
..."SQL Server Event Alert" Severity "011 - Specified Database Object Not Found"...
I think the problem is by default, severity 11 errors don't get logged, and SQL Server will only send out notification on an alert if it gets logged. Here's a link explaining it and provides a way to force it to be logged:
March 22, 2012 at 2:59 pm
Nice!
Thank's Chris
I was ultimately able to do what I wanted from the following link
http://sqlblog.com/blogs/tibor_karaszi/archive/2009/05/14/sp-altermessage-is-back-in-business.aspx
Cheers!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply