Enhancements to Existing Features

SQL Server 2005 has many enhancements to existing features that improve ease of use and manageability. These include enhancements for data access, failover clustering, replication, indexed views, and full-text search.

SQL Native Client (SNAC) is a new data access technology in Microsoft SQL Server 2005. SNAC is a stand-alone data access application programming interface (API) library that combines the SQL OLE DB provider and the ODBC driver, which were previously available via the Microsoft Data Access Components (MDAC) library, into one native dynamic-link library while also providing new functionality above and beyond what is supplied by MDAC.

SQL Native Client introduces a simplified architecture by way of ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.