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.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Can't update row

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 resource

dbcc opentran
sp_lock

arunbabu
Go to Top of Page

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!
Go to Top of Page
   

- Advertisement -