Creates a new SQL Server database with a new user being db_owner

CreateDatabase.sql

DECLARE @MyDatabase nvarchar(MAX);
DECLARE @MyLogin nvarchar(MAX);
DECLARE @MyPassword nvarchar(MAX);
DECLARE @SQL nvarchar(MAX);

SET @MyDatabase = 'TheDatabase';
SET @MyLogin = 'TheLoginAndUserName';
SET @MyPassword = 'TopSecret';

IF NOT EXISTS 
    (SELECT name  
        FROM master.sys.server_principals
        WHERE name = @MyLogin)
    SET @SQL = N'CREATE LOGIN ' + QUOTENAME(@MyLogin) + N'WITH PASSWORD = N' + QUOTENAME(@MyPassword,'''') + N';';
EXEC sp_executesql @SQL;

SET @SQL = N'CREATE DATABASE ' + QUOTENAME (@MyDatabase) + N';'
EXEC sp_executesql @SQL;

SET @SQL = N'USE ' + QUOTENAME (@MyDatabase) + N';' + NCHAR(13) + NCHAR(10) +
           N'CREATE USER ' + QUOTENAME(@MyLogin) + N' FOR LOGIN ' + QUOTENAME(@MyLogin) + N';' + NCHAR(13) + NCHAR(10) +
           N'ALTER ROLE db_owner ADD MEMBER ' + QUOTENAME(@MyLogin) + N';';
EXEC sp_executesql @SQL;