Firehose mode

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • David Greenberg
    #1

    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

    Tags: None
    • Erland Sommarskog
      #2
      Re: Firehose mode

      David Greenberg (davidgr@iba.or g.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@sommarsk og.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

        Comment

        • Siwy Bober
          #3
          Re: Firehose mode


          Uzytkownik "David Greenberg" <davidgr@iba.or g.ilnapisal w wiadomosci
          news:469C9971.7 050205@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


            Comment

            • Oscar Santiesteban
              #4
              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" <esquel@sommars kog.sewrote in message
              news:Xns99707AD 4B7BCCYazorman@ 127.0.0.1...
              David Greenberg (davidgr@iba.or g.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@sommarsk og.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/prodinf...ons/books.mspx

                Comment

                • Jason Lepack
                  #5
                  Re: Firehose mode

                  Error - Office.com - Microsoft Support
                  http://support.microsoft.com/kb/286199



                  On Jul 23, 8:55 pm, "Oscar Santiesteban"
                  <o_santieste... @bellsouth.netw rote:
                  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...@sommars kog.sewrote in message
                  >
                  news:Xns99707AD 4B7BCCYazorman@ 127.0.0.1...
                  >
                  >
                  >
                  David Greenberg (davi...@iba.or g.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...@sommarsk og.se
                  >
                  Books Online for SQL Server 2005 at
                  http://www.microsoft.com/technet/pro...ownloads/books...
                  Books Online for SQL Server 2000 at
                  http://www.microsoft.com/sql/prodinf...ns/books.mspx- Hide quoted text -
                  >
                  - Show quoted text -

                    Comment

                    • Erland Sommarskog
                      #6
                      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@sommarsk og.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

                        Comment

                        Previous template Next
                        Working...