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 |
|
BadBoy House
Starting Member
41 Posts |
 Posted - 2011-09-08 : 07:16:52
|
| We have a third party package which uses an SQL database. There is a record in one of the tables which we cannot update.On attempting to update the record directly within SQL server we get the following message:No row was updated.Error Message: Timeout Expired. The timeout period elapsed.We can update other records in the table no problem.We're waiting for a response back from the company that support the package but I wondered if anyone on here might know what could be locking the record, and more importantly how I might be able to look at any such locks.thanks |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-09-08 : 08:03:38
|
| Most of the time it is due to any orphan uncommitted transaction.Query the dm_tran_active_transactions DMV to find out.PBUH |
 |
|
|
|
|
|
Locked record/timeout problem