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 |
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
 Posted - 2009-05-29 : 16:05:32
|
| How do you keep logins and roles in sync on two (or more) SQL Servers? I've been looking at the SSIS Transfer Logins task but it doesn't appear to handle role membership and I'm not sure it handles password changes.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2009-05-29 : 22:28:28
|
| could do sp_help_revlogin and script it out and execute it on another server |
 |
|
|
|
|
|
Keeping logins and roles in sync on two servers