Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Moving/copying users between DB's

Author  Topic 

pompel
Starting Member

1 Post

Posted - 2009-03-13 : 06:30:01
I'm about to upgrade a system by restoring original DB to a new DB (on the same SQL 2005 server) with a new DBname.

How do I expand logins to be users of the new DB? (The users are allready in place in the new DB by the restoring). It's approximate 350 users, so a script to handle the issue is what I'm asking for.

Thank you in advance for any answers!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-03-13 : 07:32:57
Use this:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119748
Go to Top of Page

heavymind
Posting Yak Master

115 Posts

Posted - 2009-03-13 : 07:46:23
read how to move a database http://db-staff.com/index.php/microsoft-sql-server/83-how-to-move-database

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com
Go to Top of Page
   

- Advertisement -