If you open the table returning a large number of records, the SQL server
goes into "firehose" mode, which basically means that it's dumping a
godawful amount of data all at once. You have to wait until it is finished
before you can do anything to the table.
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -----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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
