I have a problem, using local vfp table i could create a local cursor from a table and a temporary cursor. I am having trouble reproducing this on sql server. I create a temporary table on sql server through pass through (sql exec). what i thought i might do is to create a remote view that reference this tempory table, a message saying that the object name appears, can anybody tell me please..... if this is correct or am i just barking up the wrong tree. looking at the temp table through sql server is fine, and even creating a local cursor from the temp table is fine so it looks like the creation of the temp tabbe is ok. the command for the remote view is below.

create sql view myview2 remote connect 'csmis' share as select * from ref_addr where ref_no in (select distinct ref_no from #me4)

I have tried placing tempdb in front of #me4 also dbo i am lost any body help please


TIA.