I am wanting to learn how to diagnose locking problems on a query by
looking at locking data in SP_Lock and not SQL Profiler. Books on line
describes what each column means, but I would like an example to know
what actions to take if I find 2 SPIDs competing for resources. For
example, should I kill one or the other or do something else altogether.

Help appreciated. Thanks.
Frank



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!