David Greenberg (davidgr (AT) iba (DOT) org.il) writes:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

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

Uzytkownik "David Greenberg" <davidgr (AT) iba (DOT) org.il> napisal w wiadomosci
news:469C9971.7050205 (AT) iba (DOT) org.il...
not whole table but only e.q. TOP 10

br
Bober

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 (AT) sommarskog (DOT) se> wrote

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


On Jul 23, 8:55 pm, "Oscar Santiesteban"
<o_santieste... (AT) bellsouth (DOT) net> wrote:

Jason Lepack (jlepack (AT) gmail (DOT) com) writes:
Ah, that was a very special situation. Thanks for the link, Jason.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx