Transaction can not start while in firehose mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vinodkus@gmail.com - 01 Mar 2008 08:35 GMT

dear sir/madam
When I open enterprse manager and wants to change some record and
try to save then it gives a messaage
Transaction can not start while in firehose mode.

Thanks in Advance

Reply to this Message

Tibor Karaszi - 01 Mar 2008 09:40 GMT

Try to scroll down to the bottom of the result. EM isn't really the best tool for such operations.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> dear sir/madam
> When I open enterprse manager and wants to change some record and
> try to save then it gives a messaage
> Transaction can not start while in firehose mode.
>
> Thanks in Advance

Reply to this Message

TheSQLGuru - 01 Mar 2008 15:28 GMT

Better would be to write your own UPDATE statement to modify the record of
concern.

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

> dear sir/madam
> When I open enterprse manager and wants to change some record and
> try to save then it gives a messaage
> Transaction can not start while in firehose mode.
>
> Thanks in Advance

Reply to this Message