Menu
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.
376
Expand SQL Server Agent, expand Jobs, right-click the job, and then click Properties. In the Owner list, select a login. You must be a system administrator to change the owner of a job. Assigning a job to another login does not guarantee that the new owner has sufficient permission to run the job successfully.
To change the schema of a table by using SQL Server Management Studio, in Object Explorer, right-click on the table and then click Design. Press F4 to open the Properties window. In the Schema box, select a new schema. ALTER SCHEMA uses a schema level lock.
One of the easiest ways to determine the database owner is to view its properties. Using either SQL Server Management Studio (SSMS) or Azure Data Studio (ADS) drill down to the database, right click on it, and select Properties to open the following window. Under the Database heading, you'll see its owner.
Click the Database Access tab. In the list at the top, in the Permit column, select the check box for the database to which you want to assign the owner role for the CES administrative account. In the Permit in Database Role list, select db_owner. Click OK.
Surpisingly, it's called sp_changedbowner.
You can actually change it in SQL Server Management Studio under Database / Properties / Files
142
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
