• Hi Jigman,

    quote:


    'Transaction cannot start while in firehose mode'


    One of our developers had this when updating a table in EM

    The only thing I could find in BOL relating to this was...

    quote:


    The client cannot send any other Transact-SQL statements on that connection until the application has either processed all the rows returned by SQL Server or sent SQL Server a request to cancel the rest of the results. No updates can be done on the connection until all the results have been processed; the result sets are read-only.

    Note Firehose cursor is an obsolete term for default result sets.


    Laters

    *I didn't do anything it just got complicated*


    "I didn't do anything it just got complicated" - M Edwards