http://wardyit.com/blog/blog/archive/2005/12/12/65.aspxBelow are the steps to generate a deadlock so that the behaviour of a deadlock can be illustrated: -- 1) Create Objects for Deadlock Example USE TEMPDB CREATE TABLE dbo.foo (col1 INT) INSERT dbo.foo SELECT 1 CREATE TABLE dbo.bar (col1 INT) INSERT dbo.barenCommunityServer 2.1 SP1 (Build: 61025.2)http://wardyit.com/blog/blog/archive/2005/12/12/65.aspx#11550Thu, 28 May 2009 21:55:51 GMTa571ac07-9c60-4a47-9a5c-9bf2382f2f8e:11550Claypole's World - The SQL Server Side<p>One of the many reasons I love consulting is that you get the opportunity to work in diverse businesses,</p> http://wardyit.com/blog/blog/archive/2005/12/12/65.aspx#12421Fri, 05 Feb 2010 10:07:49 GMTa571ac07-9c60-4a47-9a5c-9bf2382f2f8e:12421Ajay kumar<p>Thx a lot</p>