IF CONVERT(VARCHAR(8000), SERVERPROPERTY('ProductVersion')) NOT LIKE '[1-8].%'
    BEGIN
        DECLARE @sql VARCHAR(8000)             
        SELECT  @sql = '
ALTER DATABASE ' + DB_NAME() + ' SET SINGLE_USER WITH ROLLBACK
IMMEDIATE ;
ALTER DATABASE ' + DB_NAME() + ' SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE ' + DB_NAME() + ' SET MULTI_USER;
'
        EXEC(@sql)
    END