Give the parameter values according to your requirement.
Parameter Information:-
BEFORE EXECUTE SCRIPT, PLEASE CHANGE THE VALUE OF FOLLOWING
@NewUser_Name 'Put the new user name here'?
@NewUser_Password 'Put the password for new user'
@DatabaseName 'Put the database name, where you want to create user'
@NewSchema_Name 'Put the new schema name'
Note :- IF @NewSchema_Name not provided or @NewSchema_Name is null then default schema is dbo.
Please post your comments and suggestion.
Thanks I advance
Vinay Kumar