Cannot start transaction while in firehose mode in SQL

SQL data Modification error and solution

f 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.

Solution

Follow the below solution to overcomes the above issue

Once changes made in SQL, just move the arrow once UP / Down to update the changes.