...
In SQL Server Management Studio (SSMS)
Create Paste the query below to create the tracs_log database.
Code Block |
---|
USE master GO CREATE DATABASE tracs_log GO use tracs_log GO DECLARE @sql1 VARCHAR(1000) SELECT @sql1='ALTER DATABASE '+quotename(db_name())+' SET ALLOW_SNAPSHOT_ISOLATION ON ALTER DATABASE '+quotename(db_name())+' SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE '+quotename(db_name())+' SET read_committed_snapshot ON ALTER DATABASE '+quotename(db_name())+' SET MULTI_USER' exec(@sql1) |
...