Accidently assigned dbo to a low level login

  • Help. A new application required installation of a new database on an existing SQL Server 2005 Enterprise Ed server. Somehow, the database User "dbo" got associated with the Login name we use for low level application users "DBuser".

    When I try to delete the db_owner role for DBUser, I get an error stating that dbo cannot be changed.

    I've tried reading BOL for answers, but I cannot find a clear-cut explanation of what I need to do. (I would like to change dbo to one of our existing Windows logins)

    Elliott

  • EXEC sp_changedbowner 'newdbowner'

    Best Regards,

    Chris Büttner

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

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