Hello,

Not sure why no results other then the linked server is not called within a view, procedure, table, or function in the given database. Please do me a favor and run the code outside of the stored procedure, and make sure the temp tables are indeed getting populated with a name, if they are and no data is coming back, check to make sure the database you are running in does indeed use the linked server. sys.sysobjects is a database specific view and not server wide. Lastly, no reason to add the drop statements in as running in a stored procedure the tables are dropped for you upon completion.