SQL Server Error-transaction can not start while firehose Mode

SQL Server Error-transaction can not start while firehose Mode

Today, I used em to modify a field in a table in the SQL-SERVER, And the SQL-SERVER prompts when I exit:

"Transaction can not
Start while firehose mode"

(Firehose is a type of cursor mode provided by the system. It is used when EM directly accesses the table. According to the data, it is called "firehose" because its connection is always in the open state ", to provide query speed. Transactions cannot be executed in this mode .)

The detected record is not modified. Because I was editingProgram, Which needs to read this table, so thought this is the reason, but when I close, Retry is still the same, and then checked online, only to find this is Microsoft admitted a SQL-SERVER problem, and provides the solution:

1. scroll down to the end of the table before you make any changes to the data in the grid. (After opening the table, return all rows ----> drag down the scroll bar --> until all data is displayed --> modify)
2. Before you initiate a failover, make sure that you are not displaying the results of any table or view.

The problem was solved easily, but he thought it was not great: Microsoft had a problem with the product (although he did not admit it was a bug ), A large number of people around the world followed in order to find the cause of the error, wasting time without knowing how much time they actually did not learn, nnd.