--Script to verify snapshot isolation enabled
SELECT name
, s.snapshot_isolation_state
, snapshot_isolation_state_desc
, is_read_committed_snapshot_on
FROM sys.databases s
go
--Script to enable snapshot isolation level
ALTER DATABASE Compass_QA
SET ALLOW_SNAPSHOT_ISOLATION ON
go
--Script to disable snapshot isolation level
ALTER DATABASE Compass_QA
SET ALLOW_SNAPSHOT_ISOLATION OFF
go
--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...
select schema_name(tab.schema_id) as [schema_name], pk.[name] as pk_name, substring(column_names, 1, len(column_names)-1) as [columns],...
--Execute the following script against the User Database where you need to find DB User permission. DECLARE @sql VARCHAR(2048) ,@sort INT...
Comments