Create Database MS Sql Server

create_database.sql

CREATE LOGIN {{username}} WITH PASSWORD = '{{strong_password}}';
CREATE DATABASE {{database_name}};
ALTER DATABASE {{database_name}} SET RECOVERY SIMPLE;
ALTER AUTHORIZATION ON DATABASE::{{database_name}} TO {{username}};
SELECT suser_sname (owner_sid), * FROM sys.databases ORDER BY name WHERE name = '{{database_name}}';

--FOR WINDOWS LOGIN
create login [<<DOMAIN\USERNAME>>] from windows;

-- For older versions of SQL Server:
EXEC sys.sp_addsrvrolemember @loginame = N'<<DOMAIN\USERNAME>>', @rolename = N'sysadmin';

-- For newer versions of SQL Server:
ALTER SERVER ROLE [sysadmin] ADD MEMBER [<<DOMAIN\USERNAME>>];

GO