Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-15 : 07:05:46
|
| Jay writes "SirI am Updating data in Table but it does not allow me to update.It Fire error message "Transaction cannot start while in firehose mode"What is that?Please Help me.Thanks in Advance.Jay" |
|
|
SqlShaun
Starting Member
14 Posts |
Posted - 2005-02-15 : 09:53:26
|
| SYMPTOMSIf you attempt to make changes to a row in a table displayed in SQL Server Enterprise Manager (SEM), unless you scroll down to the end of the table (the last row of the table), Enterprise Manager returns the following error: Cannot start transaction while in firehose mode. CAUSEWhen using SEM to display the rows from a table, all rows are returned by a "firehose cursor"; however, only the rows that are displayed have been processed. A "firehose cursor" refers to how the server sends rows to the client as fast as the client can process them. Rows that are not displayed in the Enterprise Manager are not processed and, therefore, they remain in the network buffer.The "Cannot start transaction while in firehose mode" error occurs when an OLE-DB provider attempts to perform a join transaction with results pending and while not in an updateable cursor mode. WORKAROUNDScroll all the way down to the last row of the table. This forces all the rows to be processed. You can then edit the row needed and execute the update. |
 |
|
|
|
|
|
Database-Update