By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,740 Members | 844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,740 IT Pros & Developers. It's quick & easy.

Which Sql Server error number is used when a table has a deadlock?

P: n/a
I want to set an alert for a specific table whenever an event has
caused a deadlock to occur on the table.

I understand how to set up an alert. But I don't know which error
number to use for the New Alert error number property for a deadlock.
Or how to specify a deadlock on a specific table.

Thanks,
DW

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
(da*********@hotmail.com) writes:
I want to set an alert for a specific table whenever an event has
caused a deadlock to occur on the table.

I understand how to set up an alert. But I don't know which error
number to use for the New Alert error number property for a deadlock.
The error number for deadlock is 1205.
Or how to specify a deadlock on a specific table.


You cannot really do that. A deadlock is not really on a table. A deadlock
can involve a number of resources. A resource *can* be an entire table,
but must often it is a key or a page in a table. Or several tables in
the same deadlock.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.