• Home
• org.bitbucket.bradleysmithllc.etlunit
• etlunit-sql-server-database
• 3.9.6
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

.bradleysmithllc.etlunit.etlunit-sql-server-database.3.9.6.source-code.sqlserver_create_db.vm Maven / Gradle / Ivy

USE MASTER

CREATE DATABASE ${databaseName};;

#if(${usesADAuth} == 'false')
CREATE LOGIN ${databaseLogin} WITH PASSWORD = '${databasePassword}', CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF
;;

USE ${databaseName}

CREATE USER ${databaseUsername} FOR LOGIN ${databaseLogin}
;;

SP_ADDROLEMEMBER @rolename='db_owner', @membername='${databaseUsername}'
;;
#end

USE ${databaseName}