Bug when open a table

Last Post 06 Apr 2007 02:33 AM by JHunter. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
JHunter
New Member
New Member

--
06 Apr 2007 02: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,
Jamie
You are not authorized to post a reply.

Acceptable Use Policy