ALTER DATABASE DatabaseName SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE DatabaseName SET ANSI_NULLS OFF 
GO
ALTER DATABASE DatabaseName SET ANSI_PADDING OFF 
GO
ALTER DATABASE DatabaseName SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE DatabaseName SET ARITHABORT OFF 
GO
ALTER DATABASE DatabaseName SET AUTO_CLOSE OFF 
GO
ALTER DATABASE DatabaseName SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE DatabaseName SET AUTO_SHRINK OFF 
GO
ALTER DATABASE DatabaseName SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE DatabaseName SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE DatabaseName SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE DatabaseName SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE DatabaseName SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE DatabaseName SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE DatabaseName SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE DatabaseName SET DISABLE_BROKER 
GO
ALTER DATABASE DatabaseName SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE DatabaseName SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE DatabaseName SET TRUSTWORTHY OFF 
GO
ALTER DATABASE DatabaseName SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE DatabaseName SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE DatabaseName SET READ_WRITE 
GO
ALTER DATABASE DatabaseName SET RECOVERY FULL 
GO
ALTER DATABASE DatabaseName SET MULTI_USER 
GO
ALTER DATABASE DatabaseName SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE DatabaseName SET DB_CHAINING OFF 
Last modified: April 29, 2019

Author

Comments

Write a Reply or Comment