I have also followed the steps in: http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/

to setup SQL Server alerts and email operator notifications but don't know how to trigger the alert from the 1st step...

OK I have created a new Agent Job and the 1st step calls the SQl Query "Blocked processes" which consist of:

SELECTCOUNT(*)

FROMsys.dm_exec_requests AS der

WHEREder.blocking_session_id > 0

What do I need...

Grant Fritchey (12/4/2012)

---

I suspect that will work.

If you query sys.dm_exec_requests, you'll see that there is a pretty easy way to spot that you have blocking:

SELECTCOUNT(*)

FROMsys.dm_exec_requests AS der

WHEREder.blocking_session_id > 0;

Now all...

Grant Fritchey (12/4/2012)

---

You could, but you'd be even better served by running a query against sys.dm_exec_requests and looking for blocked processes. This will work better because instead of having to...

Hi Mike,

Thanks for such a fast reply. Our users get a DEADLOCK when multiple people are accessing the...