Cheers
I'm not fully involved with it but I will pass that on.
My own investigations led to items such as a disconnection between
ASP.NET and SQL, where ASP.NET seems to be doing its own thing with
Column names and table names. But this scenario didn't seem to fit
(unless microsoft was having issues in the background).
I'll let them know of your suggestion and pass back any results

Thanks!

On Sun, Jul 6, 2008 at 11:03 PM, Mitch Wheat wrote:
> Hi Glenn
>
> I don't have an exact answer for you, but it sounds very similar to a
> problem colleagues were having a while back. They made the problem go away
> by explicitly closing connections in their .NET 1.1 code. Whether that fixed
> it by coincidence I'm not sure...
>
> Regards,
> Mitch
>
> -----Original Message-----
> From: SQLDownUnderList@...
> [mailto:SQLDownUnderList@...] On Behalf Of RedMan
> Sent: Thursday, 3 July 2008 7:35 AM
> To: SQLDownUnder@...
> Subject: [SQLDownUnder] All users at random times get "column 'blah' does
> not belong to table Table"
>
> Hi all
> Anyone know of any methods to track down an issue where on a SQL2005
> cluster and a web farm all users get errors such as
>
> Column 'Address_Key' does not belong to table Table.
> at System.Data.DataRow.GetDataColumn(String columnName)
> at System.Data.DataRow.get_Item(String columnName)
> at ...
>
> Cannot find table 0.
> at System.Data.DataTableCollection.get_Item(Int32 index)
>
> On any operation on the site, this occurs for all users for 10 minutes
> to half an hour 2-4 times a day.
> Basically it is getting a result set from the database but the result
> set is empty (which shouldn't be the case).
>
> We've looked at SQL connections and made sure they are not stored
> statically or in sessions and they are created once per thread.
>
> Any clues? The issues started up when jumping into a Webfarm/cluster
> environment with approx 50-100 users.
>
> After 10 minutes or so the server appears to come right by itself.
> Thanks in advance for any hints
>
>
> cheers
> Glenn.
>
>
> to unsubscribe to this list, please send a message back to the list with
> 'unsubscribe' as the subject. Powered by mailenable.com - List managed by
> http://www.readify.net
>
>
> to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net
>
>
>


to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net