I am TX replicating a db to the reporting server and the reporting side is facing a lot of deadlock issues. Please advise.
View Complete Post
If multiple threads concurrently execute code that writes to or modifies a resource, then obviously the resource must be protected with a thread synchronization lock to ensure that the resource doesn't get corrupted.
MSDN Magazine June 2006
MSDN Magazine September 2003