Solved

SQL Server 2000: sp_detach_db hung by running stored procedure

Posted on 2010-08-26
2
570 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 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

785 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