Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 606
  • Last Modified:

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?
0
SAbbushi
Asked:
SAbbushi
1 Solution
 
Guy Hengel [angelIII / a3]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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now