Cannot find the object "XXX" because it does not exist or you do not have permission

Asked 2009-10-21T15:19:20.780

I'm getting the following error when calling a stored procedure:

Cannot find the object "XXX" because it does not exist or you do not have permission.

I've checked the database and the SP is there with the correct permissions yet I'm still getting the error.

Any suggestions?

sql-server stored-procedures permissions

Edit Report

1 Answer

Always use the dbo. (or other schema) prefix both when creating and when accessing objects.

I wrote about this very topic recently:

answered 2009-10-21T15:37:12.180