How to Change the SQL Server Database Owner

• Nisarg Upadhyay

  SSC-Addicted

  Points: 495

  More actions

  July 31, 2023 at 12:00 am

  #4232598

  Comments posted to this topic are about the item How to Change the SQL Server Database Owner

• Ant-Green

  SSC Guru

  Points: 113536

  More actions

  July 31, 2023 at 8:22 am

  #4249000

  Good article.  Just one thing to note is that, "sp_changedbowner" is on the depreciated list, so I wouldn't be advertising to use that option any further and use the ALTER AUTHORISATION command instead.

  Anything that does use "sp_changedbowner" already should be in the process of being converted to ALTER AUTH instead.

  https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-changedbowner-transact-sql?view=sql-server-ver16

• MMartin1

  One Orange Chip

  Points: 27840

  More actions

  August 18, 2023 at 6:44 pm

  #4264849

  Thank you, this is informative.  Throughout I notice the word user and log in/login used interchangably maybe ?

  From Microsoft: http://learn.microsoft.com/en-us/sql/t-sql/statements/alter-authorization-transact-sql

  "Server objects (such as databases) must be owned by a server principal (a login)." So this is out of the realm of a 'user.'

   

   

  ----------------------------------------------------