I replied once to this - and it didn't 'take', so trying again, but shorter reply:

I tried using execute as login instead and am now getting:

Msg 229, Level 14, State...

I ran it as the other user. I ran it as myself (both times using execute as user). Got the same error message. Running it WITHOUT execute...

The linked server has been set up to use a generic login rather than the login used by sql server. However, when I tried to run the sp...

All users have connect permissions only

Role has execute permission - and user is part of role - this is how they are granted execute permissions -via this role

Role has deny...

The sp is querying a linked table (non-sql db) to get the records to add to the SQL Server table. The other 3 queries ARE working which have...

unfortunately not. the SP in question is supposed to add records to a table - and this isn't happening. Only when I run the app.

Is in poor taste - unless you have the male counterpart?