Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Transaction cannot start while in firehose mode

Author  Topic 

Ambikaa
Starting Member

43 Posts

Posted - 2008-08-06 : 09:27:09
Hi,

In sql enterprise manager, when i open the table to make changes in the row it returns the following error

Transaction cannot start while in firehose mode

it shows in the dialog box after i closed the table.


elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-08-06 : 09:30:41
what were you editing? were they duplicate rows maybe?
why not just write your update in T-SQL?

Em
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-06 : 13:21:22
http://support.microsoft.com/kb/286199

http://support.microsoft.com/kb/237398
Go to Top of Page
   

- Advertisement -