Post reply

dbo mapped to user

  • May 28, 2004 at 12:21 pm

    #85131

    Somehow on a production server I have dbo mapped to a sql login.  I am used to having dbo mapped to sa login.

    How can I fix this?

  • May 28, 2004 at 12:42 pm

    #508269

    sp_changedbowner will change it back to what you need.  I would check with your co-worker first before making the change because at where I am, it depend on what is the database whethere it's sa's use or user's database.  It could be both way and there's nothing wrong with that.

     

    mom

  • May 28, 2004 at 1:28 pm

    #508280

    How could I forget?  I had done this once before, maybe because it's production I am more worried.   Thanks!

     

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

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