>>>Not at the moment. What is really strange, is this only happens when we connect to a server, not our local copy of SQL Server 2005.
>>>
>>>
>>
>>How exactly you're creating these temp tables? Are you creating them in VFP?
>>
>>Can you show some code?
>
>This is one table created:
>

>    lcsql = "SELECT * INTO #runsrpt " + ;
>            "FROM RUN FULL OUTER JOIN RUNUSER ON RUN.RUN_AUTOID = RUNUSER.RUNUSER_RUN_AUTOID " + ;
>            "WHERE Run.Run_AutoID = " + ALLTRIM(STR(gnID))
>    lnRet = gocnn.execute(lcsql, @lncount)
>

>
>One table is created, then populated with the following command:
>

>    lcsql = 'INSERT INTO #RUNSCHOOL VALUES(' + lctmpstring + ')'
>    lnRet = gocnn.execute(lcsql, @lncount)
>

>lncount in both instances comes back greater then 0.

Where do you have CREATE TABLE #RunSrpt statement?