I am using COM+ and have a wrapper layer for the ADO libraries that handle error handling and abstration etc.

I need to be able to pass disconnected recordsets that contain multiple resultsets back to my clients but you cannot disconnect a recordset if you want to call the RS.NextRecordset function.

Has anyone else got any ideas?
I was thinking of returning an array of disconnected recordsets back.

(Connecting to MS SQL Server 7)