Bug when open a table

Last Post 06 Apr 2007 01:33 AM by JHunter. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

06 Apr 2007 01:33 AM
It sounds like a process has locked this table, causing the other tasks to become blocked (and timeout).

Next time this happens, run "exec sp_who2" in QA. Look for numbers in the BlkBy column - this will be the SPID of the process that is causing the problems.

Hope that helps,

Acceptable Use Policy