We have thousands of stored procedure which are not in use and we decided to drop them all (I didn't get this unused stored procs info from any user, we logged all stored procedures which are in use. By that, we got details of unused stored procs).
Now, after dropping stored procs. If any user or from application calls stored procedure it normally throws error, which is like:
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_wh'.
I need an email alert whenever my instance throws this error.
I have tried with ALERTS option under sql server agent which is not working. Also, I checked in errorlog if we can insert the log details in to a table, and this error is not logging.
NEED HELP...................... :)