Posted by Jason Lepack on 07/25/07 02:37

http://support.microsoft.com/kb/286199


On Jul 23, 8:55 pm, "Oscar Santiesteban"
<o_santieste...@bellsouth.net> wrote:
> 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" <esq...@sommarskog.se> wrote in message
>
> news:Xns99707AD4B7BCCYazorman@127.0.0.1...
>
>
>
> > David Greenberg (davi...@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, esq...@sommarskog.se
>
> > Books Online for SQL Server 2005 at
> >http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> > Books Online for SQL Server 2000 at
> >http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Hide quoted text -
>
> - Show quoted text -

[Back to original message]