database-compose.mssql-docker.create_xld_db.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of integration-server-gradle-plugin Show documentation

The easy way to get custom setup for Deploy up and running

There is a newer version: 23.3.0-1025.941

Show newest version

CREATE DATABASE xldrepo COLLATE SQL_Latin1_General_CP1_CI_AS;
GO
USE xldrepo;
GO
CREATE LOGIN xldrepo WITH PASSWORD = 'xldrepo', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF, DEFAULT_DATABASE = xldrepo;
GO
CREATE USER [xldrepo] FOR LOGIN [xldrepo];
EXEC sp_addrolemember N'db_owner', N'xldrepo';
GO
ALTER DATABASE xldrepo SET ALLOW_SNAPSHOT_ISOLATION ON;
GO
ALTER DATABASE xldrepo SET READ_COMMITTED_SNAPSHOT ON;
GO