Script to Create User and Associate DB

[PU36]

I'm trying to create a script that will create a user account and then associate that user to the DB's for that user.

I have the following to create it but how do you have the script ask for the User name prior to creating the user.

USE [master]
GO
CREATE LOGIN [DOMAIN\USERNAME] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
GO
USE [DB]
GO
CREATE USER [DOMAIN\USERNAME] FOR LOGIN [DOMAIN\USERNAME]
GO
USE [DB]
GO
ALTER USER [DOMAIN\USERNAME] WITH DEFAULT_SCHEMA=[DOMAIN\USERNAME]
GO
USE [DB]
GO
CREATE SCHEMA [DOMAIN\USERNAME] AUTHORIZATION [DOMAIN\USERNAME]

 

[mrdenny]

T/SQL scripts can not prompt the user for information. The user has to provide all the information prior to running the script.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog