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)
 creating users on standby database

Author  Topic 

mgole
Starting Member

9 Posts

Posted - 2005-03-16 : 18:41:46
How can i create new users on standby database(read only).

Madhukar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-03-16 : 19:04:39
They come over when you restore the tlog from the source server. To get them into master (logins), you can use sp_help_revlogin which can be found by googling it.

Tara
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-03-16 : 19:25:19
you can't unless you create them in the source server first.



-ec
Go to Top of Page
   

- Advertisement -