Firehose Mode
-
-
Hi , Some times when i edit into SQL table a value , SQL server 2000 generate a message says "Transaction Cannot start while in firehose mode" can you till me what is firehose mode ?? and how can i stop that mode to make my changes free ? thank you ..
A quick search of the Microsoft web site found this: http://support.microsoft.com/default.aspx?scid=/Support/ActiveServer/faq/data/adofaq.asp[^] * (SQL Server specific) With a forward-only, read only-cursors (aka Firehose cursors) against SQL Server, you cannot start a transaction on that connection. This is because the connection is dealing with the cursor and needs to complete what it's doing (get to the end of the cursor) before continuing. If this does not help answer your question you need to be more specific. e.g. What technologies are you using to connect to SQL Server.
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums