Database Owner | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database Owner

When I create a database it establishes myself as owner of the database, obviously. Is there a way to set the SA account to be the owner automatically or will I need to run the sp_changedbowner procedure every time? [8D] ———-
T Kelley
MS, MCDBA, OCA, CIW
Create the database while logged in with the SA account.
"How do you expect to beat me when I am forever?"
Boy do I feel clueless! I knew that, I have to many database servers and was confused! LOL Thanks ———-
T Kelley
MS, MCDBA, OCA, CIW
Valid tip, and the better option to include SP_CHANGEDBOWNER in the database creation script, which will ensure your thing to achieve. HTH Satya SKJ

]]>