I thought that you had to explicitly drop any temporary tables created with the hash syntax as soon as you had finished using it.
Personally when ever I used to have to use this type of temporary table I always made sure that it was dropped as soon as I finished using it. If you are using SQL2000 or above you could always use the @table variable which is a much better performer and you do not have to worry about dropping it after you have finished using it. > 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:239975 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