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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Deadlock issues

Author  Topic 

ninel
Posting Yak Master

141 Posts

Posted - 2007-03-05 : 10:43:35
How can I write code to trap the deadlock error and re-submit the transaction in SQL?

Does anyone have any sample code?

Thanks,
Ninel



spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-03-05 : 11:51:31
look into sp_lock.

resubmitting the query won't automagicaly solve your deadlock problems.

Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page
   

- Advertisement -