Editing Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Preacher Man - 27 Oct 2005 20:09 GMT

I am new to SQL so please be patient. I have a database in SQL 2000. When
I expand the Database, Tables window, I right click on a table and select
return all rows. When I try to edit data in some of the fields it tells me,
"Transaction cannot be started while in firehose mode". What in the world
does this mean.

Reply to this Message

Raymond D'Anjou - 27 Oct 2005 21:32 GMT

A lot of people here will tell you...
DON'T use Enterprise Manager to Insert/Update/Delete date.
USE Query Analyser.

I've use EM in the past but not anymore.
As you've just found out, EM is buggy for this kind of job.

Follow this link for more:
http://www.aspfaq.com/show.asp?id=2455

>I am new to SQL so please be patient. I have a database in SQL 2000. When
>I expand the Database, Tables window, I right click on a table and select
>return all rows. When I try to edit data in some of the fields it tells
>me, "Transaction cannot be started while in firehose mode". What in the
>world does this mean.

Reply to this Message

Jonathan Miller - 31 Oct 2005 06:30 GMT

I edit tables from the enterprise manager all of the time and have never
encountered this error. However, I did find a MS article about this, it
turns out it is a known bug.

http://support.microsoft.com/?id=286199

> I am new to SQL so please be patient. I have a database in SQL 2000. When
> I expand the Database, Tables window, I right click on a table and select
> return all rows. When I try to edit data in some of the fields it tells me,
> "Transaction cannot be started while in firehose mode". What in the world
> does this mean.

Reply to this Message