setrzoom.blogg.se - Multiple idatabase registration windsor npoco

ALTER DATABASE SET READ_WRITEĪfter creating the database, we will move on to creating the customers table.ALTER DATABASE SET TARGET_RECOVERY_TIME = 0 SECONDS.ALTER DATABASE SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ).

ALTER DATABASE SET PAGE_VERIFY CHECKSUM.

ALTER DATABASE SET HONOR_BROKER_PRIORITY OFF.

ALTER DATABASE SET READ_COMMITTED_SNAPSHOT OFF.

ALTER DATABASE SET PARAMETERIZATION SIMPLE.

ALTER DATABASE SET ALLOW_SNAPSHOT_ISOLATION OFF.

ALTER DATABASE SET DATE_CORRELATION_OPTIMIZATION OFF.

ALTER DATABASE SET AUTO_UPDATE_STATISTICS_ASYNC OFF.

ALTER DATABASE SET RECURSIVE_TRIGGERS OFF.

ALTER DATABASE SET QUOTED_IDENTIFIER OFF.

ALTER DATABASE SET NUMERIC_ROUNDABORT OFF.

ALTER DATABASE SET CONCAT_NULL_YIELDS_NULL OFF.

ALTER DATABASE SET CURSOR_DEFAULT GLOBAL.

ALTER DATABASE SET CURSOR_CLOSE_ON_COMMIT OFF.

ALTER DATABASE SET AUTO_UPDATE_STATISTICS ON.

ALTER DATABASE SET AUTO_CREATE_STATISTICS ON.ALTER DATABASE SET ANSI_NULL_DEFAULT OFF.IF (1 = FULLTEXTSERVICEPROPERTY( 'IsFullTextInstalled' )).ALTER DATABASE SET COMPATIBILITY_LEVEL = 110.( NAME = N 'DbCustomers' , FILENAME = N 'c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\DbCustomers.mdf', SIZE = 4096KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ).