NET version 2.0: Managed Providers * Server Enumeration Provides support for enumerating active instances of Microsoft SQL Server 2000 and later.* Asynchronous Processing Allows you to perform asynchronous database operations using an API that is modeled after the asynchronous model used by the . * Multiple Active Result Sets (MARS) Allows an application to have more than one Sql Data Reader open on a connection when each instance of SQLData Reader is started from a separate command.* Bulk Copy Operations Enables you to perform fast bulk inserts using the . * New SQL Server Max Data Types Provides support for varchar(max), nvarchar(max), varbinary(max), and xml data types in SQL Server 2005.
* Transactions with SQL Server Snapshot Isolation Provides support for snapshot isolation, a SQL Server 2005 mechanism designed to reduce blocking in OLTP applications.
* Database Mirroring in SQL Server 2005 Provides support for database mirroring in SQL Server 2005 with new connection string syntax for specifying a failover partner server.
* SQLXML 3.0 in SQL Server 2005 SQL Server 2005 exposes the functionality of SQLXML 3.0 inside the Microsoft . Developers can write applications that access XML data from an instance of Microsoft SQL Server and process the data in the .
NET Framework environment, sending updates back to SQL Server.
* Provider Statistics Provides support for retrieving runtime statistics in SQL Server 2005. NET Framework applications to change password of a user account without requiring administrator intervention.