SQL Server已提交读快照隔离级别的设置

if(charindex(‘Microsoft SQL Server 2005‘,@@version) > 0)  
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  

select is_read_committed_snapshot_on from sys.databases where name = DB_Name()