Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DeepGround
Yak Posting Veteran
73 Posts |
 Posted - 2011-07-07 : 16:42:53
|
| So I am getting this error when trying to view the tables of a database. I run sp_who and I see 3 spids accessing the database. Once is AWAITING COMMAND though and it says not to kill when it says that according to this article.http://msdn.microsoft.com/en-us/library/ms173730.aspx |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DeepGround
Yak Posting Veteran
73 Posts |
Posted - 2011-07-07 : 18:14:54
|
| I eventually decided to kill one and it made it stop. It looks like it was something the web application initiated. |
 |
|
|
|
|
|
Lock request time out period exceeded