Posted by Oscar Santiesteban on 07/24/07 00:55

Erland,

Doesn't FIREHOSE mode mean that EM has read the records in a "forward only
cursor" and has no means of updating? Hence the name "firehouse" which is a
rapid stream of data only going 1 way.

Oscar

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99707AD4B7BCCYazorman@127.0.0.1...
> David Greenberg (davidgr@iba.org.il) writes:
>> I'm in Enterprise Manager and have made a change to a row.
>> When I try to update I get a message that says:
>> Transaction cannot start, Firehose mode"
>>
>> Can anyone explain what this is and what it means ?
>
> It means that you should open a Query Analyzer window and write an UPDATE
> statement.
>
> My guess is that EM has at this point not yet retrieved all rows, and
> since the result set is still open, the connection does not permit a
> new operation to be initiated. Note that this has more implications
> than just not being able to update the row. It also means that SQL
> Server needs to keep the untrieved rows locked.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]