Posted by Greg D. Moore \(Strider\) on 12/20/07 03:47

"Justin" <justinmiyashiro@hotmail.com> wrote in message
news:b55a5933-55ee-401f-b78f-bb703953a3f9@i29g2000prf.googlegroups.com...
>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.

Add the users on Server A.






--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]