>How do I return a cursor (temp table created in SQL Server stored procedure) back to VFP application?
Finish your SP with:
SELECT * from #TempTable
But why using temp table? Why not use table variable? When you use temp table you must care about uniqueness of its name.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.