Firehose mode in SQL Server
I saw this super odd error message from SQL Server today:
Transaction cannot start while in firehose mode
Firehose mode? What's that?
Microsoft says:
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. After the failover occurs and after you reconnect to the virtual server, only a batch of the rows in the table are processed. The error message shown in the "Symptoms" section occurs when an OLE-DB provider attempts to perform a join transaction, with results pending, while not in an updateable cursor mode.
You can read the whole KB article at http://support.microsoft.com/?id=286199.
This error occured when I was hacking around in a SQL Server database. I right clicked on a table, and opened all rows. I edited the first row, and closed the table. That's when this error popped up.
So if this ever happens to you, just scroll all the way down to the bottom of the table, then scroll all the way back up to the beginning. That will solve it. Or just use SQL to manipulate your data...
There are no comments for this entry.
[Add Comment]