AZR-SQL101

-- Drop master key IF EXISTS (SELECT * FROM sys.symmetric_keys WHERE name = '##MS_DatabaseMasterKey##') DROP MASTER KEY; -- Create master key CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<<ReallyStrongPassword>>'; GO Till Next Time

-- Remove existing user DROP USER IF EXISTS [<<UserName>>] GO -- Create new user CREATE USER USR_CROSS_DBMS WITH PASSWORD = '<<Really Strong Password>>',   DEFAULT_SCHEMA=[dbo] GO -- Add user to the database owner role EXEC sp_addrolemember N'db_owner', N'<<UserName>>' GO Till Next Time

-- Drop if exsists DROP DATABASE IF EXISTS [<<MyDatabaseName>>] GO -- Create new database CREATE DATABASE [<<MyDatabaseName>>] ( EDITION = 'STANDARD', SERVICE_OBJECTIVE = 'S0' ) GO Till Next Time