Ryan Ryan - 2 months ago 6
SQL Question

How do you change the owner of a database in sql?

In management studio you can see the owner under properties but it won't let you change it. My guess is there's some stored procedure to change it and you can't do it through the gui.

Answer

Surpisingly, it's called sp_changedbowner.

You can actually change it in SQL Server Management Studio under Database / Properties / Files

Comments