Post reply

Changing database owner

  • January 8, 2008 at 10:10 am

    #185260

    Hi all,

    I need to change the production database owner while the applications attached to that database running.

    I was wondering if it can break anything?

    Thanks

  • January 8, 2008 at 10:53 am

    #765820

    I don't think so. Nothing has ever broken the dozen or so times I've run sp_changedbowner.

    Greg

    Greg

  • January 8, 2008 at 11:02 am

    #765821

    Thanks Greg,

    I have changed the database owner and everything seems fine so far.

  • January 8, 2008 at 11:03 am

    #765822

    I hope the application is not using the present owner as its user when accessing the DB. Then it might break depending on the code I guess..

    -Roy

  • January 8, 2008 at 12:28 pm

    #765862

    The application is using different sqlUserID and password, so it should be OK.

Viewing 5 posts - 1 through 4 (of 4 total)

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