USE [master] GO CREATE DATABASE [MY_DB_01] ON ( NAME = N’MY_DB’, FILENAME = N’E:\DATA\MY_DB.ss’ ) AS SNAPSHOT OF [MY_DB]; GO — REVERT TO SNAPSHOT USE [master] GO — Close existing connections DECLARE @Sql VARCHAR(1000) SET @Sql = ” SELECT @Sql = @Sql + ‘kill ‘ + CONVERT(NVARCHAR(3), [spid]) + ‘;…