July 31, 2023 at 12:00 am
Comments posted to this topic are about the item How to Change the SQL Server Database Owner
July 31, 2023 at 8:22 am
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.
August 18, 2023 at 6:44 pm
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.'
----------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply