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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Transfers logins

Author  Topic 

gercr
Yak Posting Veteran

53 Posts

Posted - 2004-11-04 : 09:29:00
Hi all, I have implement loging ship, but I need to transfers the logins and password from server A to server B, al least one time per day.

X002548
Not Just a Number

15586 Posts

Posted - 2004-11-04 : 10:32:14
I believe you'd have to dump and restore maste....never had to do this though



Brett

8-)
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-11-04 : 21:45:21
doesn't log shipping do that for you?
otherwise, you could create a dts package for login transfer.

--------------------
keeping it simple...
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-11-04 : 21:55:35
No log shipping does not do that for you.

gercr, the e-mails that we have been exchaning today did not help? Did you not find sp_helprevlogin in the forums?

Tara
Go to Top of Page
   

- Advertisement -