Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Kill procceses

    Try this script before restore. Works for years.

    ___________________________________

    -- Kill all processes for the DB

    DECLARE @DBName VARCHAR(100)

    SET @DBName = 'MyDatabase001' -- db_name()

    DECLARE @RecordID INT

    DECLARE Cursor_Work CURSOR LOCAL

    FOR SELECT spid FROM...

Viewing post 1 (of 1 total)