Posted by Justin on 12/20/07 02:41

I have 2 sql server 2000 database that participate in log shipping.
Server A is the source database, which log ships to a database on
Server B. The database on Server B is in a warm stand by/read only
mode. Is there a way that I can add users to the database on Server
B, without having to add the users to the database in server A? I am
trying to use the database on Server B as a reporting only database
and add more users to have permissions to run reports.

Please let me know if anyone has any suggestions. Thank you.

[Back to original message]