Home Forums SQL Server 2008 SQL Server 2008 - General Grant db_datareader database role to a user for a readonly database RE: Grant db_datareader database role to a user for a readonly database

  • January 13, 2011 at 3:21 pm

    #1273318

    You create a login and user on the source system.

    You then migrate that login to the new system (the user will come through log shipping) using the same SPID.

    This should help: http://support.microsoft.com/kb/246133