What is it and how can it stop it cancelling my updates from Enterprise Manager?
This is related to editing data in large tables using Enterprise Manager. The so called Firehose mode indicates that Enterprise Manager has not fetched all rows. When you right-click a table, and then click "Return all rows," a firehose cursor is opened and only the rows that have been processed are displayed.
See also this Microsoft Support article.
Maybe this can help you: