Developer's Guide (Database Engine)

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#.

  • Native XML Web Services Concepts
    Describes Native XML Web Services available through the Database Engine by using Hypertext Transfer Protocol (HTTP), SOAP, and Web Services Definition Language (WSDL).

  • SQL Server 2008 R2 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, 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)
    Contains information about SQL Server Management Objects (SMO), a collection of objects that are designed for programming all aspects of managing SQL Server.

  • SQL Database Management Objects (SQL-DMO)
    Contains information about the SQL Server Database Management Objects (SQL-DMO), a collection of COM objects that are designed for programming all aspects of managing SQL Server.

    This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

  • 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.