Versions Compared

Version Old Version 2 New Version 3
Changes made by

David Malisch

Julian Pazynski

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. In SQL Server Management Studio (SSMS)

    1. Paste the query below to create the tracs_support database. You should use the copy button in the code snippet below.

Code Block
languagesql
USE master
GO
CREATE DATABASE tracs_support
GO
use tracs_support
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) 

...