Home Forums SQL Server 2008 SQL Server 2008 Administration Kill All Spid(s) according to Database Name RE: Kill All Spid(s) according to Database Name

  • June 14, 2012 at 7:44 am

    #1501008

    Following works fine with me in scheduled restore.

    ALTER DATABASE DatabseName

    SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    GO

    --DO restore

    ALTER DATABASE DatabseName

    SET MULTI_USER

    GO