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