Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2000: sp_detach_db hung by running stored procedure

Posted on 2010-08-26
2
Medium Priority
?
605 Views
Last Modified: 2012-05-10
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?
0
Comment
Question by:SAbbushi
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 33539585
you cannot do anything, except wait OR restart the whole sql server instance
0
 

Author Closing Comment

by:SAbbushi
ID: 33561035
Thank you.That's what I did.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Integration Management Part 2
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question