Home Forums Article Discussions Article Discussions by Author Discuss content posted by Yichang Chen Resolving User Security Identifier (SID) Discrepancy in Read-Only Databases RE: Resolving User Security Identifier (SID) Discrepancy in Read-Only Databases

  • December 30, 2009 at 3:05 am

    #1097365

    timothyawiseman (12/29/2009)

    I am curious, why would you want to do this instead of (temporarily) taking the database off of read only status and updating the SIDS and then returning it to read only status?

    One scenario where this might be useful is if the read-only database is a target of log shipping.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi