Error Message: Transaction cannot start while in firehose mode

Hi,
I am dealing with an application where the back-end is SqlServer2000. There
is a master table where one filed is empty that needs to be filled in with
correct value. As I am trying to add the value to this field on a particular
row, I am getting the following message: Transaction cannot start while in
firehose mode. Now I am planning to send a update command to the particular
row to fill in the blank value for the field concerned. However, before I do
that I just want to know, why I am getting the above error. Any help is
appreciated. Thanks.> As I am trying to add the value to this field on a particular row
How are you "trying to add the value"? An update statement, a stored
procedure call, pasting into Enterprise Manager's "Open Table" view, ...
--
http://www.aspfaq.com/
(Reverse address to reply.)|||I was trying to add the blank field value from Enterprise Manager, by right
clicking and opening the table and choosing all row option and then going to
the right record and the blank field to fill it up. At this point, I got the
above message. I would like to know why I am getting such message and is it
safe to run a update query to update the blank field in one record via Query
Analyzer. Thanks
"Aaron [SQL Server MVP]" wrote:
> > As I am trying to add the value to this field on a particular row
> How are you "trying to add the value"? An update statement, a stored
> procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||If your table has a primary key (or a unique way to identify a single row),
then yes, I would use an UPDATE statement in Query Analyzer. Enterprise
Manager has its purposes, but data manipulation is not one of them. Please
have a look through this article: http://www.aspfaq.com/2455
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
> I was trying to add the blank field value from Enterprise Manager, by
right
> clicking and opening the table and choosing all row option and then going
to
> the right record and the blank field to fill it up. At this point, I got
the
> above message. I would like to know why I am getting such message and is
it
> safe to run a update query to update the blank field in one record via
Query
> Analyzer. Thanks
> "Aaron [SQL Server MVP]" wrote:
> > > As I am trying to add the value to this field on a particular row
> >
> > How are you "trying to add the value"? An update statement, a stored
> > procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >|||Thanks for the help Aaron. I appreciate it.
"Aaron [SQL Server MVP]" wrote:
> If your table has a primary key (or a unique way to identify a single row),
> then yes, I would use an UPDATE statement in Query Analyzer. Enterprise
> Manager has its purposes, but data manipulation is not one of them. Please
> have a look through this article: http://www.aspfaq.com/2455
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Jack" <Jack@.discussions.microsoft.com> wrote in message
> news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
> > I was trying to add the blank field value from Enterprise Manager, by
> right
> > clicking and opening the table and choosing all row option and then going
> to
> > the right record and the blank field to fill it up. At this point, I got
> the
> > above message. I would like to know why I am getting such message and is
> it
> > safe to run a update query to update the blank field in one record via
> Query
> > Analyzer. Thanks
> >
> > "Aaron [SQL Server MVP]" wrote:
> >
> > > > As I am trying to add the value to this field on a particular row
> > >
> > > How are you "trying to add the value"? An update statement, a stored
> > > procedure call, pasting into Enterprise Manager's "Open Table" view, ...
> > >
> > > --
> > > http://www.aspfaq.com/
> > > (Reverse address to reply.)
> > >
> > >
> > >
>
>|||Chances are the table does not have a valid PK and is causing the error.
--
Andrew J. Kelly SQL MVP
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:C2FBA83A-46B0-4F54-85CA-7D829462E75B@.microsoft.com...
>I was trying to add the blank field value from Enterprise Manager, by right
> clicking and opening the table and choosing all row option and then going
> to
> the right record and the blank field to fill it up. At this point, I got
> the
> above message. I would like to know why I am getting such message and is
> it
> safe to run a update query to update the blank field in one record via
> Query
> Analyzer. Thanks
> "Aaron [SQL Server MVP]" wrote:
>> > As I am trying to add the value to this field on a particular row
>> How are you "trying to add the value"? An update statement, a stored
>> procedure call, pasting into Enterprise Manager's "Open Table" view, ...
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>