MS SQL Server - Editing Data

Author

Editing Data

Preacher Man

2005-10-27, 5:17 pm

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.

Thomas

2005-10-27, 5:17 pm

from microsoft:

PRB: SQL Enterprise Manager Returns "Cannot Start Transaction While in
Firehose Mode" Error
View products that this article applies to.
Article ID : 237398
Last Review : October 15, 2002
Revision : 1.0
This article was previously published under Q237398
SYMPTOMS
If you attempt to make changes to a row in a table displayed in SQL Server
Enterprise Manager (SEM), unless you scroll down to the end of the table (the
last row of the table), Enterprise Manager returns the following error:
Cannot start transaction while in firehose mode.
CAUSE
When using SEM to display the rows from a table, all rows are returned by a
"firehose cursor"; however, only the rows that are displayed have been
processed. A "firehose cursor" refers to how the server sends rows to the
client as fast as the client can process them. Rows that are not displayed in
the Enterprise Manager are not processed and, therefore, they remain in the
network buffer.

The "Cannot start transaction while in firehose mode" error occurs when an
OLE-DB provider attempts to perform a join transaction with results pending
and while not in an updateable cursor mode.
WORKAROUND
Scroll all the way down to the last row of the table. This forces all the
rows to be processed. You can then edit the row needed and execute the
update.
--
Thomas

"Preacher Man" wrote:

> 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.
>
>
>

Preacher Man

2005-10-27, 5:17 pm

Wow. That was it.

Thanks.

"Thomas" <Thomas@discussions.microsoft.com> wrote in message
news:EA75DF26-3E76-4839-ABAB- 8CBA4FAC84BB@microso
ft.com...[color=darkred]
> from microsoft:
>
> PRB: SQL Enterprise Manager Returns "Cannot Start Transaction While in
> Firehose Mode" Error
> View products that this article applies to.
> Article ID : 237398
> Last Review : October 15, 2002
> Revision : 1.0
> This article was previously published under Q237398
> SYMPTOMS
> If you attempt to make changes to a row in a table displayed in SQL Server
> Enterprise Manager (SEM), unless you scroll down to the end of the table
> (the
> last row of the table), Enterprise Manager returns the following error:
> Cannot start transaction while in firehose mode.
> CAUSE
> When using SEM to display the rows from a table, all rows are returned by
> a
> "firehose cursor"; however, only the rows that are displayed have been
> processed. A "firehose cursor" refers to how the server sends rows to the
> client as fast as the client can process them. Rows that are not displayed
> in
> the Enterprise Manager are not processed and, therefore, they remain in
> the
> network buffer.
>
> The "Cannot start transaction while in firehose mode" error occurs when an
> OLE-DB provider attempts to perform a join transaction with results
> pending
> and while not in an updateable cursor mode.
> WORKAROUND
> Scroll all the way down to the last row of the table. This forces all the
> rows to be processed. You can then edit the row needed and execute the
> update.
> --
> Thomas
>
>
> "Preacher Man" wrote:
>

2005-10-27, 5:17 pm

Using Enterprise Manager to insert, update and/or delete data in SQL is far
from good practice. T-SQL (or an appropriate client application - which I
presume you do not have) gives you a lot more control over what you're trying
to achieve.

And if you post DDL and some sample data, we can help you find a better
solution, than simply going through rows in EM.

ML

stoney

2005-10-27, 5:17 pm

http://support.microsoft.com/defaul...;EN-US;Q237398&

stone out

"Preacher Man" wrote:

> 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.
>
>
>

Raymond D'Anjou

2005-10-27, 5:17 pm

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

"Preacher Man" <nospam> wrote in message
news:%23XYYLoy2FHA.2816@tk2msftngp13.phx.gbl...
>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.
>

David Gugick

2005-10-27, 5:17 pm

Preacher Man wrote:
> Wow. That was it.
>
> Thanks.
>
>

The real key here is to not edit data in SQL EM, exactly because of the
way data is returned.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com

Jonathan Miller

2005-10-31, 3:23 am

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

"Preacher Man" wrote:

> 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.
>
>
>

Sponsored Links