May 24, 2010 at 10:11 pm
Hii Leo
thanx for the efforts.
Even i don't knw the full flow of application, there's a lot of dependencies we r trying to consolidate the same,
as soon as i will get the full flow of application i will let u knw.
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
May 26, 2010 at 7:41 am
Here is the Bible for this area:
http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx
Note there are 2 additional parts to this blog series.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 26, 2010 at 10:12 am
This is an interesting one.
What Gila Monster mentioned makes most sense to me.
According to this, Truncate table acquires the Sch-M (schema modification) lock:
Whereas a delete won't acquire this lock. So wouldn't changing the truncate to a delete work?
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply