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