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.
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. |
|
|
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. |
|
|
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. |
|
|
Nicholson
Starting Member
8 Posts |
Posted - 2011-01-05 : 13:48:17
|
Thanks, appreciate the insight. |
|
|
|
|
|