>>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.