Database Engine Developer Documentation

THIS TOPIC APPLIES TO: yesSQL ServeryesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server provides a rich set of tools for developing, administering, and controlling database applications.

In This Section

Common Language Runtime (CLR) Integration Programming Concepts
Describes the integration of the common language runtime (CLR) component of the .NET Framework for Microsoft Windows in SQL Server. This means that you can write stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions, using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#.

SQL Server Native Client Programming
Describes how SQL Server Native Client can be used to create new applications or enhance existing applications to take advantage of new SQL Server features such as multiple active result sets (MARS), user-defined data types (UDT), query notifications, snapshot isolation, and XML data type support.

SQLXML 4.0 Programming Concepts
Describes the latest version of SQLXML, which delivers the same functionality as SQLXML 3.0 as well as additional updates to accommodate new features introduced in SQL Server 2005 (9.x), such as the xml data type.

WMI Provider for Configuration Management Concepts
Describes a published layer that is used with the SQL Server Configuration Manager snap-in for Microsoft Management Console (MMC) and the Microsoft SQL Server Configuration Manager. It provides a unified way for interfacing with the API calls that manage the registry operations requested by SQL Server Configuration Manager and provides enhanced control and manipulation over the selected SQL Server services.

WMI Provider for Server Events Concepts
Describes how to use Windows Management Instrumentation (WMI) to monitor events in an instance of SQL Server.

SQL Server Management Objects (SMO) Programming Guide
Contains information about SQL Server Management Objects (SMO), a collection of objects that are designed for programming all aspects of managing SQL Server.

Database Engine Extended Stored Procedure Programming
Describes how to use extended stored procedures to create your own external routines in a programming language such as C.

Data Collector Programming
Describes the Data Collector object model.

Exception Message Box Programming
Describes how you can use the exception message box programmatic interface in your applications to provide more control over the messaging experience, to give your users the option to save error message content for later reference, and to get help with messages.

See Also

Data Mining Programming
Analysis Services Developer Documentation
Integration Services Developer Documentation
Replication Developer Documentation
Reporting Services Developer Documentation