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 |
|
kostbad
Starting Member
5 Posts |
 Posted - 2014-09-16 : 06:21:06
|
| Whenever i'm trying to change any data in a specific row in my DB, sql management just keeps executing the sql query forever.This happens only in a specific row (of a table that contains customers and their data).What could be the problem in situations like that? |
|
|
Arun Babu N
Starting Member
26 Posts |
Posted - 2014-09-16 : 06:26:35
|
| check any open transaction are there. and check whether your qry get blocked by other resourcedbcc opentransp_lockarunbabu |
 |
|
|
kostbad
Starting Member
5 Posts |
Posted - 2014-09-16 : 06:58:33
|
| opentran returns no problem.I tried using sp_who2 and i get a line that says something like:SUSPENDED ....blocked by 256...command UPDATE....SPID 88.How do i read/troubleshoot this?edit: ok i got it. I used activity monitor to kill the 256 process.Thanks for your help! |
|
|
|
|
|
|
Can't update row