SQL Server Programming Overview
Application programming interfaces (APIs) are the mechanisms used by applications to access resources on the local computer or available through a network. Microsoft SQL Server 2005 supports several classes of APIs that applications can use to access SQL Server resources.
In This Section
| Topic | Description |
|---|---|
A programmatic interface installed with and used by SQL Server 2005 graphical components. |
|
SQL Server 2005 features the integration of the common language runtime (CLR) component of the .NET Framework for Microsoft Windows. |
|
A stand-alone data access API used for both OLE DB and ODBC. |
|
Delivers the same functionality as SQLXML 3.0, plus updates to accommodate new features introduced with SQL Server 2005. |
|
A number of administration APIs used to create database and administration applications. |
|
Several technologies used to access data and metadata stored on an instance of Analysis Services. |
|
Several technologies used to perform administrative tasks on an instance of Analysis Services. |
|
Includes an object model that makes programming packages easier and more flexible. |
|
Enables you to both simplify repeated replication tasks and improve the user experience for your replication-based applications. |
|
Several programming interfaces you can leverage in your own applications. |
|
Notification Services object models, XML schemas, tables, views, and codes. |
|
Defining and developing the components required to create an application that uses Service Broker. |
|
The Microsoft Extended Stored Procedure API provides a server-based API for extending SQL Server functionality. |