Got it...Thanks....

-----Original Message-----
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 2:38 PM
To: CF-Talk
Subject: RE: OT - SQL Firehose mode??


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

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to