And the linked table, does this role have the appropriate permissions on it?
Have you tried to run the proc while logged in as a user in that role (not yourself) from within ssms?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events