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.
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 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
|