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 |
|
nomadsoul
Yak Posting Veteran
89 Posts |
 Posted - 2006-12-10 : 17:25:08
|
| Hi everyone,I'm trying to move myDB along with it's new logins to a new server and I found this script:http://www.databasejournal.com/img/sp_help_revlogin.sqlthat lets you do that.I'm just not sure what I'm to change or if I should change anything, detach the db before running the script or after? etc..Seems alot of these articles leave out details that are important to newer users like me.thanks in advanceIt is better to be prepared and not have an opportunity than to not be prepared and have an opportunity |
|
|
itsonlyme4
Posting Yak Master
109 Posts |
|
|
nomadsoul
Yak Posting Veteran
89 Posts |
Posted - 2006-12-12 : 17:10:38
|
| I'm hollerin yall,I tried the script and got an error that it didn't know where or what master..sysxlogins (don't remember exactly)Ok where do I insert my own object names etc..It looks like anice script and I'd love to live it and learn it. It is better to be prepared and not have an opportunity than to not be prepared and have an opportunity |
 |
|
|
|
|
|
Login Script