Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Server 2008 Settings - Database Owner

Author  Topic 

Nicholson
Starting Member

8 Posts

Posted - 2011-01-04 : 15:46:55
Is there a way to change the settings in SQL Server 2008 so that the owner does not default to the user who creates the database?

E.g., I would like for this to default to SA.

I have also noticed that when a restore is performed, this same default applies.

Does anyone know what other triggers there are for this default?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-01-04 : 15:50:01
You can't override this behavior but you can however use exec sp_changedbowner 'sa' after you create it.
Go to Top of Page

Nicholson
Starting Member

8 Posts

Posted - 2011-01-04 : 16:21:52
Okay, that's what I was afraid of. Thanks for confirming.

Also, do you know what other triggers there are for this default?

I've noticed that when I perform a restore, the same behavior occurs.
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-01-04 : 16:37:08
quote:
Also, do you know what other triggers there are for this default?
There are no "triggers" except creation or restoration of a database for the first time on the server/instance. Unless you change it the owner remains the same even if you restore the database from a backup.
Go to Top of Page

Nicholson
Starting Member

8 Posts

Posted - 2011-01-05 : 13:48:17
Thanks, appreciate the insight.
Go to Top of Page
   

- Advertisement -