Temporary Table Creation Problem in CF7 not CF6.1

[Ortho]

We have been preparing for our upgrade to CF7.0 from 6.1 on a test site with a
test mssql database and come across an issue we cannot resolve. Maybe someone
can help.

We cannot create a LOCAL temporary table in the mssql database with CF7 but
can with CF6.1. Using Enterprise Manager we can create a LOCAL temporary table
and it seems the problem is with CF7 specifically. We can create a GLOBAL
temporary table in CF7 just fine so the problem is only with LOCAL temporary
table creation in CF7.

Here is the code element to create the LOCAL table that gives the problem in
CF7 but not in 6.1:
<cfquery username ="#userName#" password ="#passWord#" name="test"
datasource="#DSource#">
select testid into ##ctest from testtable
</cfquery>

[philh]

Local temp tables live only for the duration of the connection that created
them. Perhaps CF7 is timing out the data connection in the middle of your
process.

Does the code throw an error, or not? If so, what error does it return?

[Ortho]

There is not an error; the file is just not created so when you try to access
the table, it is not there and then you get a standard error message.

We verified the file was not created in Enterprise Manager.