I have a requirement where I will be executing a stored procedure(e.g sp_one param1,param2,p aram3) using a OPENQUERY in SQL Server 2000.

The sp_one inturn executes another stored procedure
(e.g sp_two param1,param2,p aram3) which has a temporary table(#temp) being used for saving multiple phonenumber in it.

(sp_one calls sp_two which has #temp) using OPENQUERY

When I execute sp_one using OPENQUERY...