Cannot start transaction while in firehose mode?? 1

[JohnBates]

Hi all -

I attempted to modify a row, via the SQL Server Enterprise
Manager. I got error "Can not start transaction while in
firehose mode."

I am able to modify data in other tables and have recently been able to modify the above table.

Found nothing in SQL Server Help Topics.

Does anyone know what this message means?

thanks for any help. John

 

[ChrisSharratt]

John,

Should be easy enough to resolve, just scroll to the end of the table in Enterprise Mgr, and then return back to the point where you want to edit the data.

SQL EM can only modify the lines when it's read all the records... A "Firehose Cursor" is just the method that it uses to read these records.

Hope that helps,
Chris Sharratt

 

[JohnBates]

Thank you Chris. The "firehose" problem has been resolved. BTW, who called the fire dept.?

John