Features of SQL Native Client

In addition to exposing features contained in the most recent version of the Microsoft Data Access Components (MDAC), SQL Native Client also implements many other features to take advantage of new functionality provided by SQL Server 2005.

Note

Although MDAC supports SQL Server 2005, MDAC does not exploit certain features found in it. You must use SQL Native Client to take advantage of these new features.

In This Section

Topic	Description
Using Database Mirroring	Discusses how SQL Native Client supports the use of mirrored databases, which is the ability to keep a copy, or mirror, of a SQL Server 2005 database on a standby server.
Performing Asynchronous Operations	Discusses how SQL Native Client supports asynchronous operations, which is the ability to return immediately without blocking on the calling thread.
Using Multiple Active Result Sets (MARS)	Discusses how SQL Native Client supports multiple active result sets (MARS), which is the ability to execute and receive multiple result sets using a single database connection
Using XML Data Types	Discusses how SQL Native Client supports the XML data type, which is a SQL Server 2005 XML-based data type that can be used as a column type, variable type, parameter type, or function return type.
Using User-Defined Types	Discusses how SQL Native Client supports User-Defined Types (UDT), which extends the SQL type system by allowing you to store objects and custom data structures in a SQL Server 2005 database.
Using Large Value Types	Discusses how SQL Native Client supports large value data types, which are large object data types (LOB) that are supported in SQL Server 2005.
Changing Passwords Programmatically	Discusses how SQL Native Client supports the handling of expired passwords so that passwords can now be changed on the client without administrator involvement.
Working with Snapshot Isolation	Discusses how SQL Native Client supports the enhancement to row versioning that improves database performance by avoiding reader-writer blocking scenarios.
Working with Query Notifications	Discusses how SQL Native Client supports consumer notification on rowset modification.
Performing Bulk Copy Operations	Discusses how SQL Native Client supports bulk copy operations that allow the transfer of large amounts of data into or out of a SQL Server table or view.
Using Encryption Without Validation	Discusses how to use SQL Native Client to encrypt data sent to the server without validating the certificate.

See Also

Other Resources

SQL Native Client Programming

Help and Information

Getting SQL Server 2005 Assistance