Delete Never Finishes 1

[OrWolf]

This is in SQL 7 (Please don't ask). I have a record that I cannot delete. In the table I'm able to delete other records, but this one just sits (I've let it run for over 6 minutes). The table only has 28K rows. Other records in the table can be deleted. This record also has certain fields that cannot be deleted while others easily save updates. I've been unable to find something consist with the datatype of the fields that fail as some nvarchar work and other nvarchar do not. Please let me know if you have any ideas. Thank you!

 

[AlexCuse]

Wow, I will not complain about using 2000 at work anymore ;-). Probably a dumb question, but are there any relationships involved?

Ignorance of certain subjects is a great part of wisdom

 

[mrdenny]

I would assume that some other user has a lock on the record or page.

While the delete is sitting there running open another query analyzer window and run "sp_who2". This will give you some info on what the hold up is, if you are being blocked, etc.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

How about....are there any triggers on the table that might be stopping the delete?

-SQLBill

Posting advice: FAQ481-4875

 

[onpnt]

deadlock is my first guess as well

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}