Re: Error Message: Transaction cannot start while in firehose mode

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/16/04 

Date: Mon, 15 Nov 2004 22:32:43 -0500

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