Hello,

I would just like to clarify a few points:-

1) When you say “delegation settings r done” does that mean you are using the Linked Server security option of “(connections will) Be made using the login’s current security context”?

2) The SP is on the Linked Server, not the Local Server - correct?

3) Are the Owners of the Object (XYZ) and the SP the same?

4) What versions of SQL Server are the Linked and Local Servers?

Regards,

John Marsh