I have a linked server login on all of my machines. The associated database user has is a member of db_datareader and db_datawriter within each user database. The user has also been granted EXECUTE, to be able to exec all procs.
the linked servers are each running under the context of this user
i am executing a proc remotely, and continually failing w/this:
Msg 1088, Level 16, State 7, Procedure procedurename, Line 19
Cannot find the object "tablename" because it does not exist or you do not have permissions.
the procedure does an insert into a table. the user is a member of db_datawriter.
i have used this linked server definition a gazillion times. i can't determine the source of this problem.
the table is definitely there. logged in locally, the proc runs just fine