The only thing I can think of is that you've got this table being created somewhere else in your code, or maybe the create statement is in a loop. Running it from QA doesn't tell you anything because it's a different user/session, and temp tables are specific to the session.
> -----Original Message----- > From: Brian Peddle [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 09, 2006 10:52 AM > To: CF-Talk > Subject: Sql Server Temp Table > > 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. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239972 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
