Microsoft SQL Server Cheat Sheet

mssql-cheatsheet.sql

-- create user
-- sqlcmd -S <ComputerName>\<InstanceName> -E -i mssql_user_setup.sql  -v db=<DbName> -v user=<UserName>  -v password=<Password>
use [$(db)];
go
create schema $(user);
go
create login $(user) with PASSWORD = '$(password)';
create user $(user) for login $(user) with DEFAULT_SCHEMA=$(user);
go
grant alter to $(user);
go
grant control to $(user);
go