Technical Reference (Database Engine)

Find the tools, languages, and administration programming reference documentation for the Database Engine in Microsoft SQL Server 2008. 

 Errors and Events

     Database Engine Events and Errors

     Error Messages in Visual Database Tools

 Feature Reference

     Database Engine Tuning Advisor F1 Help

     Full-Text Search F1 Help

     SQL Server Browser Service

     SQL Server Management Studio F1 Help

     More…

 Tools Reference

     Command Prompt Utilities

     XML Input File Reference (Database Engine Tuning Advisor)

 SQL Server Event Class Reference

     SQL Server Event Class Reference

 Transact-SQL Language Reference

     Data Types (Transact-SQL)

     Functions (Transact-SQL)

     Operators (Transact-SQL)

     System Stored Procedures (Transact-SQL)

     System Views (Transact-SQL)

     More…

 Xquery Language Reference

     XQuery Basics

     XQuery Expressions

     XQuery Functions against the xml Data Type

     XQuery Operators Against the xml Data Type

     More…

 Exception Message Box Class Library

     Microsoft.SqlServer.MessageBox

 SQL Server Management Objects (SMO) Class Library

     Microsoft.SqlServer.Management.Common

     Microsoft.SqlServer.Management.Smo

     Microsoft.SqlServer.Management.Smo.Broker

     Microsoft.SqlServer.Management.Smo.Agent

     Microsoft.SqlServer.Management.Smo.RegisteredServers

     More…

 SQL Server Data Collector Class Library

     Microsoft.SqlServer.Management.Collector

 WMI Provider for Configuration Management Classes

     SqlService Class

     ClientSettings Class

     ClientNetworkProtocol Class

     ServerSettings Class

     ServerNetworkProtocol Class

     More…

 SQL-DMO Reference

     SQL-DMO Reference