Sql Server Temp Table

2006-05-09 Thread Brian Peddle
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

Re: Sql Server Temp Table

2006-05-09 Thread Rob Wilkerson
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

RE: Sql Server Temp Table

2006-05-09 Thread Munson, Jacob
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

Re: Sql Server Temp Table

2006-05-09 Thread Andy Mcshane
: 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

Re: Sql Server Temp Table

2006-05-09 Thread Neil Middleton
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

RE: Sql Server Temp Table

2006-05-09 Thread Brian Peddle
. -Original Message- From: Neil Middleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 09, 2006 2:37 PM To: CF-Talk Subject: Re: Sql Server Temp Table 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