Are you guys sure you aren't talking about ##temp_table? On 5/9/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote: > > I'm having to work to establish recall, here, but I thought I > remembered that temp tables were maintained until the connection is > broken. Do you have "Maintain Connections" checked in your DS > properties, by any chance? Has anything else changed in the > environment? > > On 5/9/06, Brian Peddle <[EMAIL PROTECTED]> wrote: > > Today I just started to get an error: > > > > [Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object > > named '#temp_reports' in the database. > > > > If I take the query from coldfusion and run in analyzer it works as > > expected, it is just inside CF that I have the issue. I recycled the CF > > services in hopes to break any connections, I also recycled the SQL > Server > > service and still no luck. > > > > Any insight? > > > > > > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239984 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
