Home Forums SQL Server 2005 Administering Drop Database - Can it Fail ? RE: Drop Database - Can it Fail ?

  • October 2, 2015 at 5:14 pm

    #1831189

    homebrew01 (7/28/2015)

    Any opinion on this method ?

    ALTER DATABASE MyDatabase SET OFFLINE WITH ROLLBACK IMMEDIATE

    Thanks! That worked for me and I was able to kill unkillable the SPIDs <50 and put it into single user mode in my own process.