This often happens when you open a table that has a large amount of records in the enterprise manager. The enterprise manager, to save resources will not return all the records at once and throws this error when you try to insert a record. There are several things you could do, one of them might be to return only the top 1 record before entering a new one.
Jeff -----Original Message----- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 1:42 PM To: CF-Talk Subject: OT - SQL Firehose mode?? Why do I get this strange error when I try to add text to a column in SQL while in open table mode? "Transaction cannot start while in firehose mode" I'm adding text to a nvarchar column with 255 chars. Thanks. Robert O. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
