Sunday, April 3, 2011

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.

From stackoverflow
  • Surpisingly, it's called sp_changedbowner.

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

  • Actually you can change it in SSMS, it's in the Files tab on the database properties.

0 comments:

Post a Comment