> >USE [master] >GO > >DECLARE @UserName VARCHAR(5) >DECLARE @SqlStatement nvarchar(MAX); > >SET @UserName = '75080' > >SET @SqlStatement = 'CREATE LOGIN [NC-Coleman\' + @UserName + '] FROM WINDOWS' >EXECUTE (@SqlStatement); > >EXECUTE ('CREATE DATABASE [' + @UserName + ']') > >SET @SqlStatement = N'USE [' + @UserName + '];CREATE USER [' + @UserName + '] FOR LOGIN [NC-Coleman\' + @UserName + ']' >EXECUTE (@SqlStatement); >GO >