Home

Definition of multiple active result set

A SQL Server 2005 feature that provides the ability to have more than one pending request per connection, in particular to have more than one default result set open per connection. SQL Server 2000 and earlier restricted the programming model such that at any point in time there would be at most one pending request on a given session, blocking the driver from sending requests to the server until the entire result set is consumed.

Computer Science