Just odd.
-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
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
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 SQL20
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 Messa
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
5 matches
Mail list logo