Firehose
-
Hello I have a problem while trying to edit a record on SQL Server 2000 (Sp 3). The problem occures, w hen I click to "Return all rows" in the context menu of the table, and I tried to uptade a record . It occures an error. The error message says : "Transaction cannot start while in firehose mode" I have researched a little about firehorse, but could not find any useful information. I look forward to hearing from you thanks Best Regards Emre YAZICI
-
Hello I have a problem while trying to edit a record on SQL Server 2000 (Sp 3). The problem occures, w hen I click to "Return all rows" in the context menu of the table, and I tried to uptade a record . It occures an error. The error message says : "Transaction cannot start while in firehose mode" I have researched a little about firehorse, but could not find any useful information. I look forward to hearing from you thanks Best Regards Emre YAZICI
Firehose mode or firehose cursor is a forward only readonly way of going throug data. Is this in Enterprise Manager? Is this problem consistent, or only on a certain table?
-
Firehose mode or firehose cursor is a forward only readonly way of going throug data. Is this in Enterprise Manager? Is this problem consistent, or only on a certain table?
thanks for your help There are lots of tables, It occures just for ONE table. We are using a client of a network The database is on the SERVER of the network There is a strange thing that I do not understand I am able to update the record , when I add a new record. e.g. There are 10 records I have added a new one, after I updated the 8th one . After this there are 11 records, and the 8th record has been updated successfully. please contact for further information if necessary Best Regards Emre YAZICI