CREATE PROCEDURE dbo.Create_Login
	@username sysname
AS
BEGIN
	SET NOCOUNT ON
	DECLARE @SQL NVARCHAR(4000);
	
	SET @SQL = 'CREATE LOGIN ' + @username + ' WITH PASSWORD = ''12345'', DEFAULT_DATABASE=[dbname], DEFAULT_LANGUAGE=[British], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON';
	EXECUTE(@SQL);
	
	EXEC sys.sp_addsrvrolemember @loginame = @username, @rolename = N'sysadmin';
	
	SET @SQL = 'ALTER LOGIN ' + @username + ' DISABLE';
	EXECUTE(@SQL);
END;

declare @userid sysname = 'jon', @password sysname = 'password', @sqlstr nvarchar(250)
      exec sp_addlogin @loginame = @userid,
		@passwd = @password,
		@defdb = 'ToolboxDB',
		@deflanguage = [British],
		@sid = null,
		@encryptopt= null
      EXEC sys.sp_addsrvrolemember @userid, @rolename = N'sysadmin'
USE [ToolboxDB]
set @sqlstr = 'CREATE USER '+@userid+' FOR LOGIN '+@userid
EXECUTE sp_executesql @sqlstr

exec sp_addlogin @loginame = @userid,
		@passwd = @password,
		@defdb = 'ToolboxDB',
		@deflanguage = [British],
		@sid = null,
		@encryptopt= null

      EXEC sys.sp_addsrvrolemember @userid, @rolename = N'sysadmin'

USE [ToolboxDB]
set @sqlstr = 'CREATE USER '+@userid+' FOR LOGIN '+@userid
EXECUTE sp_executesql @sqlstr