SQL: Change DB Owner to ‘SA’

SQL: In case you didn’t know ‘sp_changedbowner‘ is being deprecated, instead use ‘ALTER AUTHORIZATION ON DATABASE::ReplaceThisWithYourDBName to sa;

Ref:

  • Deprecation:¬†https://technet.microsoft.com/en-us/library/ms178630(v=sql.110).aspx
  • Alter Authorization:¬†https://technet.microsoft.com/en-us/library/ms187359(v=sql.110).aspx

Leave a Reply

Your email address will not be published. Required fields are marked *