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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-05-11 : 01:35:01
|
| Dear Experts,please explain me what is the exact use of DBO. ?some time while creating a procedure, we are starting like that...ex : create procedure dbo.customer_list()and in some select statements also we are using the complete path like server.database.object.when should we use like this? and what is the 100% benifit of using like this?thank you very muchVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-11 : 01:50:49
|
DBO stands for database owner. An object created under dbo schema is accessible to all the users provided they have necessary permissions to access it. On the other hand, if you don't specify DBO while creating an object, the default owner for that object will be the user who created it."and in some select statements also we are using the complete path like server.database.object"This naming convention is used for accessing objects from linked server. But you miss object owner name there:Select * from Server.Database.Owner.Object Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-05-11 : 02:03:02
|
| can i say linked server is nothing but the registered server (another server registered in my server?) of another system?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-11 : 02:15:08
|
| Not exactly but similar to it. The difference is that with Linked server, you can add server from heterogeneous sources (like ORACLE, ACCESS).Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-05-11 : 02:21:07
|
| Thank you very much HarshVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-11 : 09:34:02
|
| If you are talking about register remote sql server on your local em, it completely different from linked server. |
|
|
|
|
|
|
use of DBO.