• Maddave (11/21/2014)


    There is still one or more connections to the database. Exec sp_who2 and look to see what connections are connected to your database.

    Not if this completed successfully

    USE [master]

    ALTER DATABASE [TESTFULL] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

    GO

    So, burning question is did it complete successfully?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉