Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2002-06-27 : 13:12:43
|
| Hello! How do i create SP or SQL script for SQL mail that automatically send deadlock information to the mail box whenever there are locking problems on database or table. For example, if spid 52 transaction are blocking spid 53 ,and it cause deadock, SQl mail will automatically send those information to mailbox.Thanks for your help! |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-06-27 : 13:24:33
|
| Deadlocking can be a complex issue. A good place to start is a thorough background reading of the subject from Microsoft: [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224453[/url].Jonathan Boott, MCDBA |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-27 : 14:23:33
|
| Some more useful links....Q251004 INF: How to Monitor SQL Server 7.0 Blocking[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q251004[/url]Q271509 INF: How to Monitor SQL Server 2000 Blocking[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q271509[/url]Q224453 INF: Resolving SQL Server 7.0 or 2000 Blocking Problems[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q224453[/url]Deadlocks involving blocks[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servdatabse_8v5f.asp[/url][url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q169960[/url][url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q118552[/url][url]http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/proddocs/diag/75528frt.asp [/url]HTHJasper Smith |
|
|
|
|
|
|
SQL mail for lock