SQL Server 2000: sp_detach_db hung by running stored procedure

Ran ALTER DATABASE X SET SINGLE_USER WITH IMMEDIATE ROLLBACK/SP_DETACH_DB during maintenance window around the same time that a stored procedure kicked in. Now the sp_detach_db is blocked by the stored procedure and stored procedure is being rolled back (since over 1 hour) by the sp_detach_db statement.

Question: killing the stored procedure doesn't want to release it - what would happen if we killed the ALTER DATABASE SET SINGEL_USER statement?
Is this safe? I checked sysdatabases and still see the database there, though Enterprise Manager says it's inaccessible.

Any advice on this?
SAbbushiAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
you cannot do anything, except wait OR restart the whole sql server instance
0
 
SAbbushiAuthor Commented:
Thank you.That's what I did.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.