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 |
|
cinaremre
Starting Member
1 Post |
 Posted - 2010-12-28 : 03:35:49
|
| Hi everyone,i have a problem and couldn't find any solution. Hope someone helps meI appreciate any help.Thankswhat i'm trying to do is:simply, I'm tryin to execute an insert statement and SQL throws an error. error message is "lock request time out period exceeded"i got 3 fields in my table, 1 primary key and no foreign keys. and this error occurs only in this specific table. my other tables are working fine...query executes for 5-6 minutes but nothing happens and this error occurs... |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-12-28 : 05:03:13
|
While your query is running open another qery window and execute SP_WHO2.It will show you if there is a blocking transaction.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
SQL Timeout Problem. :(