AS>SQL Server "Yukon" Beta 1 extends the support for multiple active result sets (MARS) in applications accessing the database engine. In earlier versions of SQL Server, database applications could not maintain multiple active statements on a connection when using default result sets. The application had to process or cancel all result sets from one batch before it could execute any other batch on that connection. SQL Server "Yukon" introduces new attributes that allow applications to have more than one pending request per connection, in particular, to have more than one active default result set per connection.

AS>SQL Server "Yukon" Beta 1 introduces a new feature called multiple active result sets (MARS). MARS allows client drivers to have more than one pending request per connection.