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 2000 Forums
 SQL Server Administration (2000)
 users in SQL?Very Urgent plz!!

Author  Topic 

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-07-26 : 20:29:14
Hi all,

I reattached database from on server to another server but need to transfer users too? which way i can do that?
do i have to restore master for that?

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-26 : 20:37:13
is the other system still online?

If it is, you can run a stored procedure from microsoft that will script out all the users (even the hashed passwords are included).

http://support.microsoft.com/kb/246133/

I think Derrick Leggett modified this stored procedure to also script out the default database. I'll do a quick search for that to see if I can find it. that is really useful addition, especially if you have tons of users to recreate.


-ec
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-26 : 20:45:47
Derrick has his modified version of these scripts in his blog here http://weblogs.sqlteam.com/derrickl/archive/2005/12/04/8484.aspx

look under the 'supporting scripts' section.



-ec
Go to Top of Page
   

- Advertisement -