Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Vinay Kumar,
Give the parameter values according to your requirement.
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
I am trying to move database objects from dbo shcema to new schema in sql 2008 using
An interesting idea. I saw this question asked after I was playing with table types a bit. “Can you ...
I have alot of views within a database. I know how to change the owner of the view itself but I...
I have cloned a database from another database and able to change the schema for all the objects exc...
SQL Server 2005 newbie.
User created objects which, instead of dbo, are associated with his accou...