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 |
|
swatib
Posting Yak Master
173 Posts |
 Posted - 2006-03-13 : 06:16:22
|
Consider a scenario where script of a stored proc is generated and it is executed in different server on different network. In this case that script on different server on different network executed properly but when used in an application then gives error as "Stored Proc <sp name> does not exist"Why this happens? How to resolve it?Njoy Life  |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-03-13 : 06:54:50
|
| Check the owner of the sp. It's probably been created as a user rather than dbo and so won't be available unless executed by that user or by prefixing with the user name.Also it might have been created in the wrong database or is trying to be excecuted in the incorrect daatbase.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
swatib
Posting Yak Master
173 Posts |
Posted - 2006-03-14 : 00:31:33
|
quote:
Originally posted by nr
Check the owner of the sp. It's probably been created as a user rather than dbo and so won't be available unless executed by that user or by prefixing with the user name.
Yes you are right.Thanks for the help.Njoy Life |
|
|
|
|
|
|
stored proc script failed