In this case, I am not concerned about missing data. I was more concerned about having the website down due to a problem with not being able to remove...

Thanks. I think there is a server process that accessed the file to do some cleaning and then send out the emails. I killed the process, but maybe...

It's used for a sports league website. The table that keeps track of email communication was the one that had an issue.

Solved my own problem

ALTER DATABASE DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

GO

USE DATABASE ;

GO

DELETE

FROM TABLEA

where ID=342000

GO

ALTER DATABASE DATABASE SET MULTI_USER;

GO

Nope, no error message. The query appears to execute but to delete a single record by ID doesn't complete. I let the query run for an hour and...