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 |
|
TSQLMan
Posting Yak Master
160 Posts |
 Posted - 2006-10-16 : 12:30:58
|
| I am bringing up a new SQL Server to replace an existing Server. Both are SQL Server 2000 SP4. Each Databases will bring over it's users just by re attaching the database to the new server, but I will then need to add the Server Level users. What is the best way to do that?Thanks,Brent |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-16 : 14:05:02
|
| http://www.sqlmag.com/articles/index.cfm?articleid=16090&Tara Kizer |
 |
|
|
TSQLMan
Posting Yak Master
160 Posts |
Posted - 2006-10-16 : 14:23:20
|
| Thank You, Pretty straight forward article. I don't care for the DTS Wizards, I've been frustrated using them in the past. That is what prompted me to pose the question. After trying the "copy database wizard" to copy a normalized database, I gave up on the Wizards. it wouldn't complete because FK constraints on the table being created didn't exist because the table with the foreign key hadn't yet been created on the target. Thanks again,Brent |
|
|
|
|
|
|
Copy Users from One SQL Server to another.