Versions Compared

Version Old Version 6 New Version 7
Changes made by

Julian Pazynski

Julian Pazynski

Saved on

Key

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

...

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

We need to run the WIPack now to fully configure all databases and run a DBSync too.

  1. From the Master computer

    1. Reset to Zero Pack

    2. Reset the Registry file

      1. Navigate to C:\Program Files (x86)\TraCS

      2. Edit RegistryKeyName.ini

      3. Delete everything after TraCSPack=

  2. Open TraCS on Master Computer.

    1. You should get prompted for update to run like normal.

...