SQL SERVER ERROR email alert

Question

question

jangi asked Jul 24, '22

SQL SERVER ERROR email alert

Hi All,

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...................... :)

sql2014 sqlerror

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green commented · Jul 29, 2022 at 06:41 PM

SQL Alerts under the agent should work for you.

How have you configured the alert and the database mail to do this for you?

Can you send mail normally via sp_send_dbmail?

0 ·

Answer 1 · 2022-08-01T07:33:53Z

Willjoe2442 answered Aug 1, '22

View the logs

In SQL Server Management Studio, select Object Explorer.

In Object Explorer, connect to an instance of SQL Server, and then expand that instance.

Find and expand the Management section (assuming you have permission to see it).

Right-click SQL Server Logs, select View and then choose SQL Server Log.

How do I fix SQL Server errors?

To fix errors

Right-click the Product table (Product. SQL) in Solution Explorer and select View Designer. In the Columns Grid of the designer, right-click the ShelflLife column and select Delete to delete this column from the table

Hope this helps

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question