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 |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2003-04-04 : 14:42:25
|
| Hi Folks,I have a stored procedure which has dbo as the owner, then there is the same stored procedure with xyz as the owner. When an application which accesses the stored procedure is executed which one gets picked, the one owned by dbo or the one owned by xyz?I know i will have to drop one of them.ByeRamdasRamdas NarayananSQL Server DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-04 : 14:58:38
|
| It just depends how the application is calling the stored procedure. If the application specifies the two-part name, then it uses that specific one. If the application doesn't specify the two-part name (owner.SPName), then it will first attempt to execute the stored procedure using the user's name (if the user is a member of the db_owner role, then the name is dbo so it will be dbo.SPName), so xyz.SPName. If it can't find the stored procedure (xys.SPName), then it will try dbo.SPName. If it still can't find it, then it will error out.Tara |
 |
|
|
|
|
|
Stored Procedure Owner