Stored Procedure could not be found
Posted
by Beatles1692
on Stack Overflow
See other posts from Stack Overflow
or by Beatles1692
Published on 2010-06-16T07:59:01Z
Indexed on
2010/06/16
8:02 UTC
Read the original article
Hit count: 208
We use SQL server 2008 as our RDBMS and we have a database that has a different user rather than dbo as its owner.
The problem is in one machine a stored procedure can not run unless its owner is mentioned.
If we connect to our database using this user and try to execute the following :
exec ourSP
we get a "could not find ourSP" error but this works fine:
exec user.ourSP
Does anybody knows what can lead to such a strange behavior?
© Stack Overflow or respective owner