Changing database owner SID

  • Are there negative implications if I change the database owner SID?
    I need to change the SID for installing a CLR assembly. Is there something I should check before doing that on a large production database?

  • Hi,
    you should try this in your test environment. I changed the database owner many times and nothing happend.
    But nobody knows your sql server and databases.
    What kind of user do you want to use? A sql user or windows user?
    Best regards,
    Andreas

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply