Re: Error Message: Transaction cannot start while in firehose mode
From: Jack (Jack_at_discussions.microsoft.com)
Date: 11/15/04
- Next message: jxstern: "Re: max(keyfield)"
- Previous message: Aaron [SQL Server MVP]: "Re: Error Message: Transaction cannot start while in firehose mode"
- In reply to: Aaron [SQL Server MVP]: "Re: Error Message: Transaction cannot start while in firehose mode"
- Next in thread: Andrew J. Kelly: "Re: Error Message: Transaction cannot start while in firehose mode"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 15 Nov 2004 14:37:05 -0800
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.)
> > >
> > >
> > >
>
>
>
- Next message: jxstern: "Re: max(keyfield)"
- Previous message: Aaron [SQL Server MVP]: "Re: Error Message: Transaction cannot start while in firehose mode"
- In reply to: Aaron [SQL Server MVP]: "Re: Error Message: Transaction cannot start while in firehose mode"
- Next in thread: Andrew J. Kelly: "Re: Error Message: Transaction cannot start while in firehose mode"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
