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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2012-05-12 : 11:01:42
|
| My goal is to setup a new database on an existing instance of sql server 2008 r2 database. I do not want to use the default values, but want to use the preferred recommended values for this new database. thus I have the following questions:1. The system assigns the person who is setting up the database as the dbo. However, can you tell me who the dbo should really be? Should the dbo really be the sa (system administrator)?2. When you setup a database, there is a dbo 'person' that is assigned but you also have roles the dbo owner. Thus can you tell me and/or point me to a reference that will tell me what the difference is between the dbo of the database and the dbo owner role? Also how is the dbo of the database the same as the dbo owner role?3. It looks like I can let the default value of the database set me as as dbo. However it looks like I can assign myself to other user names that are unique within the database while still use the same domain\user name to login in. Is this a good idea to allow to occcur? Can you also give me an explaination for your reason? |
|
|
|
|
|
configuration sql server