Post reply

replace dbo of database

  • November 3, 2005 at 8:07 am

    #95634

    I have a user that’s dbo on a database and she has now left the company and I need to get her login off the sql server, but I can’t.  I can’t drop her from one of our databases because she’s listed as the dbo on a few of them.  Do you know how I can replace the dbo of a database?

     

    thanks,

  • November 3, 2005 at 8:21 am

    #602155

    You can do this by executing the stored procedure sp_changedbowner '?'.  Just replace the ? with the new owner you would like to assign.

  • November 3, 2005 at 8:25 am

    #602157

    worked, thanks!

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

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