Re: Firehose mode

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/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Firehose mode

Hi
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 ?

Thanks

David Greenberg

Re: Firehose mode

Uzytkownik "David Greenberg" napisal w wiadomosci
news:469C9971.7050205@iba.org.il...
> Hi
> 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 ?
I don't know exactly what it means. But I usualay solve this problem opening
not whole table but only e.q. TOP 10

br
Bober

Re: Firehose mode

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" 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/downlo ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: Firehose mode

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


On Jul 23, 8:55 pm, "Oscar Santiesteban"
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" 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/downl oads/books...
> > Books Online for SQL Server 2000 at
> >http://www.microsoft.com/sql/prodinfo/previousversions/book s.mspx- Hide quoted text -
>
> - Show quoted text -

Re: Firehose mode

Jason Lepack (jlepack@gmail.com) writes:
> http://support.microsoft.com/kb/286199

Ah, that was a very special situation. Thanks for the link, Jason.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx