hi, Any ideas on CFs relation to the SQL ODBC ?? Because for some time now I've been getting this Error 37000, not enough memory to complete query. So, I log on to the SQL server, and apparently I can access all of the tables in the Database barring two or three. I can query most of them ...but there two or three that, when I'm querying, gives me an out of memory error. My only solution is to reset the SQL server. regards, VINCE ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

