Post reply

change database owner

  • March 19, 2011 at 9:56 am

    #235359

    I noticed that I was the owner of a production database that I had recently detached and attached. I do have sysadmin rights but I typically make sure all databases have owner set to sa. I wanted to know if I change it (sp_changedbowner), does it impact anything? i.e the app is connected to the database and there are some transactions occurring. This is SQL Server 2008.

  • March 19, 2011 at 10:09 am

    #1300922

    It shouldn't affect anything. This is a meta data change that takes a shared lock on the database, but it should not affect any transactions

  • March 19, 2011 at 11:11 am

    #1300932

    was concerned about 'breaking' something as I was not sure. Thank You Steve!

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

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