MP (6/12/2008)
Hi Carolyn,I still can't get the deadlock to show up in the log. I added the new alert that you mentioned and I added the notify operator as well to the new alert.
Is there something else I can check or do to get the message to show up in the log. I already ran the script that was mentioned in the link in the your original article.
Thanks
MP
I like this kind of articles. Wish to have a checking script to automate some of the tasks and generate a report.
Nice to see another way to catch a deadlock. I have a related post and got a few good answers recently. http://www.sqlservercentral.com/Forums/Topic514877-146-1.aspx