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 |
|
sponguru_dba
Yak Posting Veteran
93 Posts |
 Posted - 2007-11-01 : 12:19:34
|
| Hi allI have DBA group who are support to SQL Server with Specific Tool,all group numbers are in Windows 2000 group and that group having all the Databases of SQL Server.Here my Question is If I am moving Database only from One server to Other server. How to move those users.and what is use of Sp_change_user_logins procedure.Please some body help regarding this Issue.SreenivasaRaoPune,INDIA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-01 : 12:56:18
|
| Groups should be stored in Active Directory. So if you move a database from one server to the next, all you have to do is add the group to the new server. sp_change_users_login does not apply to Windows authentication.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Moving WinNT group