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 |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2007-09-20 : 13:05:48
|
| Sometime ago, I had read a posting here about where in the system we can specify default owner of all objects in user database as being a DBO.The topic came about, because somebody found out that if an object referred to in a query, does not have a fully qualified name, then it takes some time for SQL server to figure out what the owner of the object is; this causes performance problems.e.g. select * from employees and select * from dbo.employees.If anybody knows what that setting is...I will really appreciate itRegardsParesh MotiwalaBoston, USA |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-20 : 13:18:19
|
| you can use sp_changeobjectowner.but changing the owner won't help you here. only fully qualifying your tables will._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-20 : 13:19:17
|
| No such setting exists.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-09-20 : 14:28:51
|
| http://blogs.msdn.com/sqlprogrammability/archive/2007/03/23/upgrading-to-sql-server-2005-and-default-schema-setting.aspxTara this is what I remember having read, it may not be the best description I gave to the topic...so please excuse me for that.RegardsParesh MotiwalaBoston, USA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-20 : 14:36:00
|
| If your problem was not accurately described, then please ignore my post as I was posting in regards to what I understood you meant.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
DBO Ownership