Ryan Ryan - 1 year ago 81
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 Source

Surpisingly, it's called sp_changedbowner.

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download