Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
How can I change the default database owner when creating a new database in SQL Server 2008.
ALTER AUTHORIZATION ON DATABASE::MyDB TO sa;
Note, this doesn't add the new owner to db_owner (sa + sysadmin map to dbo user which is different)
Required, but never shown
6 years, 11 months ago
4 years, 8 months ago