I do not understand what MyDataBase.dbo.temptable is. I don't think you really want to make the temporary cursor part of the database.

Try:

select a.*, b.* from a, b where ... into cursor tempcursor

>I have a problem via SQL pass through. I am building a bunch of work tables on a SQL back-end via VFP, all if fine -- to a point. When I get to a certain point, I don't get the expected results I need.
>
>I am basically doing a join of two tables (SQL-Syntax)...
>

>select a.*, b.*
>   into mydatabase.dbo.temptable
>   from a, b
>   where a.id1 = b.id1
>     and a.id2 = b.id2
>

>
>If I issue this statement from within VFP, I dont get any records created in the result set, however, if I do this exact same command from within the SQL window, I get the correct 200,000 record set.
>
>I have even gone to the point of issuing a begin transaction/end transaction around this and still missing the boat. I even added a "checkpoint" to force all unwritten pages to be processed by SQL server but no luck...
>
>I am really stuck with this, any input???