Configure the Standard Database Options - Moving INOW Database from SQL Server to another SQL Server Machine - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

1. In SQL Server Management Studio, on the toolbar, click New Query.
2. In the Query tab, copy and paste the following command set.

ALTER DATABASE INOW SET ANSI_NULL_DEFAULT OFF 
GO 

ALTER DATABASE INOW SET ANSI_NULLS OFF 
GO 

ALTER DATABASE INOW SET ANSI_PADDING OFF 
GO 

ALTER DATABASE INOW SET ANSI_WARNINGS OFF 
GO 

ALTER DATABASE INOW SET ARITHABORT OFF 
GO 

ALTER DATABASE INOW SET AUTO_CLOSE OFF 
GO 

ALTER DATABASE INOW SET AUTO_CREATE_STATISTICS ON 
GO 

ALTER DATABASE INOW SET AUTO_SHRINK OFF 
GO 

ALTER DATABASE INOW SET AUTO_UPDATE_STATISTICS ON 
GO 

ALTER DATABASE INOW SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO 

ALTER DATABASE INOW SET CURSOR_CLOSE_ON_COMMIT OFF 
GO 

ALTER DATABASE INOW SET CURSOR_DEFAULT GLOBAL 
GO 

ALTER DATABASE INOW SET CONCAT_NULL_YIELDS_NULL OFF 
GO 

ALTER DATABASE INOW SET NUMERIC_ROUNDABORT OFF 
GO 

ALTER DATABASE INOW SET QUOTED_IDENTIFIER OFF 
GO 

ALTER DATABASE INOW SET RECURSIVE_TRIGGERS OFF 
GO 

ALTER DATABASE INOW SET DATE_CORRELATION_OPTIMIZATION OFF 
GO 

ALTER DATABASE INOW SET TRUSTWORTHY OFF 
GO 

ALTER DATABASE INOW SET ALLOW_SNAPSHOT_ISOLATION ON 
GO 

ALTER DATABASE INOW SET READ_COMMITTED_SNAPSHOT ON 
GO 

ALTER DATABASE INOW SET PARAMETERIZATION SIMPLE 
GO 

ALTER DATABASE INOW SET READ_WRITE 
GO 

ALTER DATABASE INOW SET RECOVERY FULL 
GO 

ALTER DATABASE INOW SET MULTI_USER 
GO 

ALTER DATABASE INOW SET PAGE_VERIFY CHECKSUM 
GO 

ALTER DATABASE INOW SET DB_CHAINING OFF 
GO

3. On the toolbar, click Execute.