rajeev.suryanarayan (10/9/2008)
Thanks guys..really appreciate you helping me out here but could you dig deeper into your expertise and forsee something 🙂 Pleasssee...
See my post above, enable the traceflag and get the deadlock graph. That will show exactly what queries were involved in the deadlock. With the graph we can help you find the cause of the deadlock and maybe even fix the root cause.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability