Though its old thread... We had same issue with Linked server created on SQL 2K5 to SQL 2K and we resolved by adding service a/c of SQL 2K5 as local...

Thats Excellent!!!!!

Thank you very much...

I can't change the existing procedure i.e, p1 becuse of dependencies...

Where in procedure p1 the o/p is generated by simple select statment using @variables

like

select @clclientname,@clclintid