• A well written and good article that presents an interesting approach. 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?

    Unless there is some reason to strictly keep it read only without exception, that seems a generally simpler answer with fewer potential side effects than this approach.

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/