Transaction cannot start while in firehose mode

This is sometimes a tricky bug to decipher. Microsoft tell us scroll to the end of the result set in enterprise manager but we have found this is not always the problem.

I certainly have found that by closing the result set that it does in fact overcome the issue but sometimes its more sinister.

I have also found that by using transaction in SQL Server i get this error. This may be due to other problems in my code but by removing begintrans and commit trans this error goes away. In fact this does suggest that a recordset has been left open elsewhere.

If you have anything else that may resolve this issue then we would welcome your comments.

Thanks