Firehose mode

When we try to change a row in a table we get an error
indicating that the transaction cannot be started while in
Firehose Mode.
We have tried scrolling to end of table and this has not
fixed the problem.
Any help is greatly appreciated.
Thanks in advanceRP wrote:
> When we try to change a row in a table we get an error
> indicating that the transaction cannot be started while in
> Firehose Mode.
> We have tried scrolling to end of table and this has not
> fixed the problem.
> Any help is greatly appreciated.
> Thanks in advance
I assume you are trying to change data from SQL EM? If so, have you
reviewed this article: http://support.microsoft.com/?id=286199
What about trying to change the data from Query Analyzer. Does that
work?
David G.|||Where exactly did you encounter this problem?
In a t-sql batch / stored procedure, etc..?
A forward-only read-only cursor is generally called a 'firehose' cursor.
This cursor is optimized for fast performance. You will be able to navigate
in a sequential FORWARD only manner. The server sends the data to the cursor
in a continous stream - and since it is read only - no inserts/updates - the
performance is very good. SQL Server decides on the kind of cursor to provide
based on various criteria - so you might not always end up with a firehose
cursor.
Reason for calling it a firehose cursor -> Keywords 'fast, forward continous
stream' - kinda resembles the water gushing out of a firemans hose.
You might have navigated to the end of the table - but the data might still
be pouring out from the server into the cursor while you were trying to
update it.
Cheers!