New and Updated Books Online Topics (5 December 2005)

New: 5 December 2005

The 5 December 2005 release of SQL Server Books Online has either had new topics added or existing topics updated in the following technologies or categories.

List of Topics

ADOMD.NET	Integration Services Programming	Samples
Analysis Management Objects (AMO)	International Considerations	SQL Server Management Objects (SMO)
Analysis Services	Notification Services Programming	Tools and Utilities
Database Engine	Replication	Transact-SQL
Full-Text Search	Replication Programming	Tutorials
Installation	Reporting Services	UI Reference
Integration Services	Reporting Services Programming	WMI Provider for Configuration Management

ADOMD.NET

• New Topics
  ADOMD.NET Client Functionality

  ADOMD.NET Client Object Architecture

  ADOMD.NET Release Differences

  ADOMD.NET Server Functionality

  ADOMD.NET Server Object Architecture

  ADOMD.NET Server Programming

  Analysis Management Objects (AMO)

  Establishing Secure Connections in ADOMD.NET

  Executing Commands Against an Analytical Data Source

  Performing Transactions in ADOMD.NET

  Retrieving Data from an Analytical Data Source

  Retrieving Data Using the AdomdDataReader

  Retrieving Data Using the CellSet

  Retrieving Data Using the XmlReader

  Retrieving Metadata from an Analytical Data Source

  User Defined Functions and Stored Procedures

  Working With Connections and Sessions in ADOMD.NET

  Working With Schema Rowsets in ADOMD.NET

  Working With the ADOMD.NET Object Model

• Updated Topics
  Migrating From ADO MD To ADOMD.NET

Back to Top

Analysis Management Objects (AMO)

• New Topics
  AMO Data Mining Classes

  AMO Fundamental Classes

  AMO OLAP Classes

  AMO Other Classes and Methods

  AMO Security Classes

  Analysis Management Objects (AMO)

  Introducing AMO Classes

  Introducing AMO Concepts

  Programming Administrative Tasks with AMO

  Programming AMO Complementary Classes and Methods

  Programming AMO Data Mining Objects

  Programming AMO Fundamental Objects

  Programming AMO OLAP Advanced Objects

  Programming AMO OLAP Basic Objects

  Programming AMO Security Objects

Back to Top

Analysis Services

• Updated Topics
  Requiring Client Authentication

  Securing Client Communication with an Analysis Services Instance

Back to Top

Database Engine

• New Topics
  About the Missing Indexes Feature

  Available Tuning Options

  Capacity Planning for tempdb

  Connecting Using IPv6

  Dialog Security for Event Notifications

  Finding Missing Indexes

  Growing and Shrinking the Buffer Pool Under NUMA

  How to: Change the Service Startup Account for SQL Server (SQL Server Configuration Manager)

  How to: Configure SQL Server to Use Soft-NUMA

  How to: Create a Stored Procedure (SQL Server Management Studio)

  How to: Delete a Stored Procedure (SQL Server Management Studio)

  How to: Grant Permissions on a Stored Procedure (SQL Server Management Studio)

  How to: Map TCP/IP Ports to NUMA Nodes

  How to: Modify a Stored Procedure (SQL Server Management Studio)

  How to: Rename a Database (SQL Server Management Studio)

  How to: Rename a Stored Procedure (SQL Server Management Studio)

  How to: Restart the SQL Server Agent Service (SQL Server Management Studio)

  How to: Set a Database to Single-user Mode (SQL Server Management Studio)

  How to: View the Definition of a Stored Procedure (SQL Server Management Studio)

  How to: View the Dependencies of a Stored Procedure (SQL Server Management Studio)

  Interpreting Execution Plans of Partitioned Objects

  Moving System Databases

  NUMA Scenarios

  Querying the SQL Server System Catalog FAQ

  Related Query Tuning Features

  Service Account Types Supported for SQL Server Agent

  SQL Server, Buffer Node Object

  Troubleshooting Metadata Visibility of Distributed Partitioned Views

  Troubleshooting Row Size Errors

  Understanding SQL Dependencies

  Unsupported Tuning Options

• Updated Topics
  Advanced Considerations for Restore Sequences

  Agent XPs Option

  Asynchronous Database Mirroring (High-Performance Mode)

  Audit Database Object Access Event Class

  Audit Database Object GDR Event Class

  Audit Database Object Take Ownership Event Class

  Audit Database Principal Impersonation Event Class

  Audit Database Scope GDR Event Class

  Audit Schema Object Access Event Class

  Audit Schema Object GDR Event Class

  Audit Schema Object Take Ownership Event Class

  Audit Server Object GDR Event Class

  Audit Server Object Take Ownership Event Class

  Audit Server Principal Impersonation Event Class

  Audit Server Scope GDR Event Class

  Audit Statement Permission Event Class

  Backup Under the Bulk-Logged Recovery Model

  Backup Under the Simple Recovery Model

  Batches

  Blocked Process Report Event Class

  Building or Refreshing a Reporting Database

  Building Statements at Run Time

  Choosing the Recovery Model for a Database

  Connecting to the SQL Server Database Engine

  Considerations for Using Test Servers

  Controlling the Locking Behavior for Bulk Import

  Copy-Only Backups

  Creating a Multiserver Environment

  Creating and Modifying Identifier Columns

  Creating SQL Server Agent Proxies

  Data Integrity

  Database Mail Architecture

  Database Mirroring and Failover Clustering

  Database Mirroring and Other Features and Components

  Database Mirroring Transport Security

  DDL Events for Use with Event Notifications

  Default Client Connection Behavior

  Default SQL Server Network Configuration

  Designing Assemblies

  Designing Event Notifications

  Detaching and Attaching Databases

  Detecting and Ending Deadlocks

  Dropping a Database Snapshot

  Ensuring a Correct Environment for a Scalable Shared Database

  Estimating the Interruption of Service During Role Switching

  Exchange Spill Event Class

  Execution Plan Caching and Reuse

  Exporting Data from or Importing Data to a Temporary Table

  Factors That Can Delay Log Truncation

  Forced Parameterization

  Full File Backups

  Guidelines and Limitations in Using XML Schema Collections on the Server

  Guidelines for Optimizing Bulk Import

  Guidelines for Performing Online Index Operations

  Hash Warning Event Class

  How Database Snapshots Work

  How Differential Backups Work

  How SQL Server 2005 Supports NUMA

  How to: Configure SQL Server Agent Mail to Use SQL Mail (SQL Server Management Studio)

  How to: Create a Maintenance Plan

  How to: Create a SQL Server Agent Master Job (Transact-SQL)

  How to: Create a Trace (SQL Server Profiler)

  How to: Create XML Input Files

  How to: Detach a Database (SQL Server Management Studio)

  How to: Drop a Database Snapshot (Transact-SQL)

  How to: Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager)

  How to: Enlist a Target Server to a Master Server (SQL Server Management Studio)

  How to: Perform Exploratory Analysis

  How to: Prepare a Mirror Database for Mirroring (Transact-SQL)

  How to: Restore a Differential Database Backup (SQL Server Management Studio)

  How to: Restore a Transaction Log Backup (SQL Server Management Studio)

  How to: Revert a Database to a Database Snapshot (Transact-SQL)

  How to: Set the Service Startup Account for SQL Server Agent (SQL Server Configuration Manager)

  How to: Set Up a Mirror Database to Use the Trustworthy Property

  How to: Set Up Database Diagram Designer (Visual Database Tools)

  How to: Start a Job (SQL Server Management Studio)

  How to: Upgrade a Database Using Detach and Attach (Transact-SQL)

  Implementing Assemblies

  Implementing Event Notifications

  Importing Data in Parallel with Table Level Locking

  Index Statistics

  Introduction to Backup and Restore Strategies in SQL Server

  Limitations on Database Snapshots

  Limiting Deleted Rows by Using TOP

  Lock Modes

  Log Shipping

  Maintenance Plan Wizard

  Maintenance Plans

  Troubleshooting a Full Transaction Log (Error 9002)

  Managing the Transaction Log

  master Database

  Maximizing Availability of a Scalable Shared Database

  Minimally Logged Operations

  model Database

  Modifying Data in Partitioned Views

  Modifying Data Through a View

  Monitoring Database Mirroring

  msdb Database

  Network Protocols, and TDS Endpoints

  OLE DB Provider for Jet

  Optimizing Bulk Import Performance

  Optimizing tempdb Performance

  Oracle Provider for OLE DB

  Overview of Database Mirroring

  Quorum: How a Witness Affects Database Availability

  Overview of Scalable Shared Databases

  Parallel Query Processing

  Performing Piecemeal Restores

  Physical Database Files and Filegroups

  Plan Forcing Scenario: Use USE PLAN to Force an Index Union Algorithm

  Possible Failures During Database Mirroring

  Overview of the Recovery Models

  Registration of Service Principal Name

  Reorganizing and Rebuilding Indexes

  Resource Database

  Row Versioning Resource Usage

  Running Jobs

  Sample XML Format Files

  Scalable Shared Databases

  Securing Data and Log Files

  Selecting an Account for the SQL Server Agent Service

  Server Memory Options

  Server Network Configuration

  Setting Database Options

  Setting Server Configuration Options

  Specifying Physical Design Structures

  SQL Native Client OLE DB Provider

  SQL Writer Service

  Considerations for Switching from the Full or Bulk-Logged Recovery Model

  Considerations for Switching from the Simple Recovery Model

  Tail-Log Backups

  tempdb Database

  Troubleshooting Database Mirroring Setup

  Transaction Log Truncation

  Typical Uses of Database Snapshots

  Understanding and Managing the suspect_pages Table

  Understanding and Managing Transaction Logs

  Understanding Non-uniform Memory Access

  Understanding Transaction Log Architecture

  Using a Dedicated Administrator Connection

  Using an XML Input File for Tuning

  Using and Modifying Instances of User-defined Types

  Using Extended Properties on Database Objects

  Using Nested Triggers

  Using SQL Server Profiler to Create and Test Plan Guides

  Using the EVENTDATA Function

  Viewing and Analyzing Traces with SQL Server Profiler

  Viewing Database Metadata

  Viewing User-defined Functions

  XML Showplans

  XML Construction (XQuery)

Back to Top

Full-Text Search

• New Topics
  Configuring Thesaurus Files

Back to Top

Installation

• New Topics
  Setting DTS Application Properties

  Configuring Integration Services in a Clustered Environment

  How to: Troubleshoot Side-by-Side Installations of SQL Server 2000 and SQL Server 2005 Reporting Services

  Installing Reporting Services on 64-bit Computers

  Upgrading dtsrun Command Lines

• Updated Topics
  Using the Package Migration Wizard

  Behavior Changes to Database Engine Features in SQL Server 2005

  Deprecated Features in SQL Server 2005 Reporting Services

  How to: Install 32-bit Reporting Services on a 64-bit Computer

  Installing Reporting Services Using Setup

  Installing SQL Server Analysis Services by Using Setup

  Installing SQL Server Analysis Services from the Command Prompt

  Installing SQL Server Integration Services

  Installing SQL Server Integration Services by Using Setup

  Installing SQL Server Integration Services from the Command Prompt

  Running Setup to Install AdventureWorks Sample Databases and Samples

  Setting Up Windows Service Accounts

  SQL Server 2005 Integration Services Backward Compatibility

Back to Top

Integration Services

• New Topics
  Creating and Running the Child Packages

  Creating New Packages

  Creating the Parent Package

  How to: Copy a Package Using SSIS Designer

  How to: Copy Package Objects

  How to: Copy Project Level Items

  How to: Designate Packages as Package Templates

  How to: Loop through Excel Files and Tables

  How to: Set Properties of Integration Services Service Using SQL Server Configuration Manager

  How to: Use Values of Parent Variables in Child Packages

  How to: View Log Entries in the Log Events Window

  Installing Packages

  Integration Services Development Enhancements

  Load-Balancing Packages on Remote Servers by using SQL Server Agent

  Managing Logging for Load Balanced Packages on Remote Servers

  Maintenance Cleanup Task

  Setting DTS Application Properties

  Using Enumerated Constants in Property Expressions

• Updated Topics
  Conditional Split Transformation

  Creating a Deployment Utility

  Creating Connection Managers

  Creating Package Configurations

  Creating Packages Using the SQL Server Import and Export Wizard

  Data Flow Task

  DataReader Source

  DATEPART (SSIS)

  Derived Column Transformation

  Excel Connection Manager

  Excel Destination

  Excel Source

  Execute Package Task

  Fast Parse

  Flat File Connection Manager

  Flat File Destination

  Fuzzy Grouping Transformation

  Fuzzy Lookup Transformation

  Handling Errors in Data

  How to: Map Query Parameters to Variables in an Execute SQL Task

  How to: Run a Package Using the DTExecUI Utility

  Implementing Logging in Packages

  Integration Services Considerations on 64-bit Computers

  Integration Services Data Types

  Integration Services Packages

  Integration Services Variables

  Lookup Transformation

  Merge Join Transformation

  Message Queue Task

  Microsoft .NET Data Provider for mySAP Business Suite

  Multiple Flat Files Connection Manager

  OLE DB Command Transformation

  OLE DB Destination

  OLE DB Source

  Percentage Sampling Transformation

  Pivot Transformation

  Row Sampling Transformation

  Script Component

  Script Task

  Sort Transformation

  SQL Server Destination

  SQL Server Compact Edition Destination

  SQRT (SSIS)

  System Variables

  Troubleshooting Package Performance

  Unpivot Transformation

  Using Checkpoints in Packages

  Using Property Expressions in Packages

  XML Source

Back to Top

Integration Services Programming

• New Topics
  Building Packages Programmatically

  Creating an ODBC Destination with the Script Component

  Developing Specific Types of Script Components

  Enhancing an Error Output with the Script Component

  Extending Packages with Custom Objects

  Extending Packages with Scripting

  Integration Services Error and Message Reference

  Logging and Defining Log Entries in a Data Flow Component

  Mapping Data Types in the Data Flow

  Parsing Non-Standard Text File Formats with the Script Component

  Reusing Package Objects

  Detecting an Empty Flat File with the Script Task

  Gathering a List for the ForEach Loop with the Script Task

  Simulating an Error Output for the Script Component

  Upgrading the Version of a Data Flow Component

• Updated Topics
  Adding Tasks Programmatically

  Coding and Debugging the Script Component

  Common Properties

  Configuring the Script Component in the Script Component Editor

  Destination Custom Properties

  Developing a User Interface for a Data Flow Component

  Developing a Custom Data Flow Component

  Developing a Custom Data Flow Component

  Extending the Data Flow with the Script Component

  Integration Services Programming

  Loading the Output of a Local Package

  Path Properties

  Loading and Running a Local Package Programmatically

  Script Task Examples

  Source Custom Properties

  Transformation Custom Properties

  Using Error Outputs in a Data Flow Component

  Using Property Expressions to Specify Property Values for Data Flow Objects

  Using Variables in the Script Task

Back to Top

International Considerations

• Updated Topics
  Session Language

Back to Top

Notification Services Programming

• Updated Topics
  EventClass Element (ADF)

Back to Top

Replication

• New Topics
  How to: Configure a Publication to Allow for Web Synchronization (SQL Server Management Studio)

  How to: Configure a Subscription to Use Web Synchronization (SQL Server Management Studio)

  Security Architecture for Web Synchronization

Back to Top

Replication Programming

• New Topics
  How to: Configure a Publication to Allow for Web Synchronization (Replication Transact-SQL Programming)

  How to: Configure a Publication to Allow for Web Synchronization (RMO Programming)

  How to: Configure a Subscription to Use Web Synchronization (Replication Transact-SQL Programming)

  How to: Configure a Subscription to Use Web Synchronization (RMO Programming)

  How to: Define a Logical Record Relationship Between Merge Table Articles (RMO Programming)

• Updated Topics
  How to: Configure Web Synchronization for Merge Replication (Replication Transact-SQL Programming)

  How to: Configure Web Synchronization for Merge Replication (RMO Programming)

  How to: Define a Logical Record Relationship Between Merge Table Articles (Replication Transact-SQL Programming)

  Upgrading Replication ActiveX Control Applications

Back to Top

Reporting Services

• New Topics
  Chart Layout How-to Topics (Report Designer)

  Reporting Services and ReportViewer Controls in Visual Studio

  Configuring Report Manager to Pass Custom Authentication Cookies

  Configuring Reporting Services to Use SSIS Package Data

  Configuring Reporting Services to Use the Microsoft .NET Framework Data Provider for mySAP Business Suite

  Customizing Style Sheets for HTML Viewer and Report Manager

  How to: Create a Report Model Data Source (Report Designer)

  How to: Create a Shared Folder for Report Server File Share Delivery

  How to: Edit or View the Source File of a Published Model or Report Definition (Report Manager)

  Starting Report Builder

  List Layout How-to Topics (Report Designer)

  Matrix Layout How-to Topics (Report Designer)

  Report Data How-to Topics (Report Designer)

  Report Graphics How-to Topics (Report Designer)

  Report Interaction How-to Topics (Report Designer)

  Report Layout How-to Topics

  Report Publishing How-to Topics (Report Designer)

  Solutions and Projects How-to Topics (Report Designer)

  Table Layout How-to Topics (Report Designer)

• Updated Topics
  Applying Transformations to XML Output

  Browser Support in Reporting Services

  Connecting to a Data Source

  How to: Add a Filter (Report Designer)

  How to: Start Report Builder

  RSReportServer Configuration File

  Specifying Credential and Connection Information

  Troubleshooting Server and Database Connection Problems

  Using Expressions in Reporting Services

Back to Top

Reporting Services Programming

• New Topics
  Creating a Custom Report Item

  Creating the Custom Report Item Design-Time Component

  Creating the Custom Report Item Run-time Component

  Custom Report Item Architecture

  Custom Report Item Class Libraries

  Custom Report Items

  Deploying a Custom Report Item

  Getting Started with a Custom Report Item Implementation

  Introducing Custom Report Items

Back to Top

Samples

• New Topics
  Replication ActiveX Controls Sample

  ReportSearch in Office Sample Application

• Updated Topics
  Array Parameter Sample

  AsynchronousRender Sample Windows Application

  Calendar-Aware Date/Time UDTs

  Create DataFlow Package Sample

  Creating a Custom Increment Task Sample

  Custom Report Item Sample

  Data Cleaning Package Sample

  File Share Data Processing Extension Sample

  FindRenderSave Sample Windows Application

  Flight Sample

  FlightNmo Sample

  ForEachDirectory Sample

  Hello World Ready Sample

  Hello World Sample

  Impersonation Sample

  Installing and Compiling Integration Services Programming Samples

  Inventory Tracker Sample

  Item Finder Sample

  Large Binary Object (LOB) Handling by Using ADO.NET

  Large Object (LOB) Handling

  Oracle TVF Sample

  Printer Delivery Extension Sample

  Profit Margin Sample

  Programming Samples

  Readme for AMOAdventureWorks Sample

  Readme for AMOBrowser Sample

  Readme for Backup and Restore Sample

  Readme for DisplayObjectNames Sample

  Readme_BackRest

  ReadMe_CheckIdentityValues

  Readme_CreateSPs

  ReadMe_DatabaseDefrag

  ReadMe_DatabaseSpace

  Readme_DependencyExplorer

  Readme_HelloWorld_CLR

  Readme_HRResume

  ReadMe_IndexSizes

  Readme_LoadRegAssembly

  Readme_ManageDatabases

  Readme_ManageDatabaseUsers

  Readme_ManageTables

  Readme_MARS

  ReadMe_RebuildAllIndexes

  Readme_ScriptTable

  Readme_ServerConnect

  Readme_ServerInfo

  Readme_ServiceBrokerConfiguration

  Readme_ServiceBrokerInterface

  Readme_ShoppingCart

  Readme_SmoBrowser

  Readme_SmoCompare

  ReadMe_SmoEvents

  Readme_SmoPing

  Readme_SmoScripter

  Readme_SqlServerList

  Readme_SqlService

  Readme_Storefront

  Readme_Tracer

  Readme_UtilityConversion

  Readme_VerifyBackup

  Readme_XmlManuInstructions

  Readme_XmlOnlineCatalog

  Readme_XmlSurvey

  Report Builder Report Samples

  Result Set Sample

  RSExplorer Sample Application

  Sales Orders Sample for Merge Replication

  Security Extension Sample

  Send DataSet Sample

  SMOTableList Sample

  Spatial Sample

  SQL Server Integration Services Samples

  Stock Sample

  Subscriber Monitor Utility Sample for Merge Replication

  Supplementary-Aware String Manipulation

  System.Transactions Sample

  UDT Utilities

  User-Defined Data Type (UDT) Sample

  UTF8 String User-Defined Data Type (UDT)

Back to Top

SQL Server Management Objects (SMO)

• Updated Topics
  How to: Create a Visual Basic SMO Project in Visual Studio .NET

  How to: Create a Visual C# SMO Project in Visual Studio .NET

  How to: Set Up a Partition Scheme for a Table in Visual Basic .NET

Back to Top

Tools and Utilities

• New Topics
  dtsrun to dtexec Command Option Mapping

• Updated Topics
  Database Engine Tuning Advisor Features

  dtutil Utility

  Editing SQLCMD Scripts with Query Editor

  Features in SQL Server Management Studio

  Integration Services in Business Intelligence Development Studio

  Introducing Business Intelligence Development Studio

  nscontrol create Command

  nscontrol delete Command

  nscontrol disable Command

  nscontrol displayargumentkey Command

  nscontrol enable Command

  nscontrol export Command

  nscontrol register Command

  nscontrol repair Command

  nscontrol status Command

  nscontrol unregister Command

  nscontrol update Command

  nscontrol upgrade Command

  rskeymgmt Utility

  Writing, Analyzing, and Editing Scripts with SQL Server Management Studio

  XML Input File Reference (DTA)

Back to Top

Transact-SQL

• New Topics
  sys.column_xml_schema_collection_usages (Transact-SQL)

  sys.dm_db_missing_index_columns

  sys.dm_db_missing_index_details

  sys.dm_db_missing_index_group_stats

  sys.dm_db_missing_index_groups

  sys.module_assembly_usages (Transact-SQL)

  sys.parameter_xml_schema_collection_usages (Transact-SQL)

• Updated Topics
  ALTER ASSEMBLY (Transact-SQL)

  ALTER DATABASE (Transact-SQL)

  ALTER PROCEDURE (Transact-SQL)

  ALTER REMOTE SERVICE BINDING (Transact-SQL)

  ALTER TABLE (Transact-SQL)

  ALTER TRIGGER (Transact-SQL)

  BACKUP (Transact-SQL)

  COLLATE (Transact-SQL)

  column_constraint (Transact-SQL)

  column_definition (Transact-SQL)

  CREATE DATABASE (Transact-SQL)

  CREATE EVENT NOTIFICATION (Transact-SQL)

  CREATE FUNCTION (Transact-SQL)

  CREATE INDEX (Transact-SQL)

  CREATE TRIGGER (Transact-SQL)

  CREATE VIEW (Transact-SQL)

  DBCC CHECKALLOC (Transact-SQL)

  DBCC CHECKCONSTRAINTS (Transact-SQL)

  DBCC CHECKDB (Transact-SQL)

  DBCC CHECKFILEGROUP (Transact-SQL)

  DBCC CHECKTABLE (Transact-SQL)

  DBCC INPUTBUFFER (Transact-SQL)

  DBCC SHOWCONTIG (Transact-SQL)

  DECLARE CURSOR (Transact-SQL)

  FROM (Transact-SQL)

  GROUP BY (Transact-SQL)

  IN (Transact-SQL)

  index_option (Transact-SQL)

  NSEventBatchList (Transact-SQL)

  OBJECTPROPERTY (Transact-SQL)

  OBJECTPROPERTYEX (Transact-SQL)

  ORDER BY Clause (Transact-SQL)

  Replication System Stored Procedures (Transact-SQL)

  SET FORCEPLAN (Transact-SQL)

  SET TRANSACTION ISOLATION LEVEL (Transact-SQL)

  sp_addarticle (Transact-SQL)

  sp_adddynamicsnapshot_job (Transact-SQL)

  sp_addextendedproperty (Transact-SQL)

  sp_addlinkedsrvlogin (Transact-SQL)

  sp_addmergearticle (Transact-SQL)

  sp_addserver (Transact-SQL)

  sp_attach_db (Transact-SQL)

  sp_attach_single_file_db (Transact-SQL)

  sp_changearticle (Transact-SQL)

  sp_changemergearticle (Transact-SQL)

  sp_create_plan_guide (Transact-SQL)

  sp_detach_db (Transact-SQL)

  sp_dropextendedproperty (Transact-SQL)

  sp_executesql (Transact-SQL)

  sp_helpstats (Transact-SQL)

  sp_mergearticlecolumn (Transact-SQL)

  sp_send_dbmail (Transact-SQL)

  sp_who (Transact-SQL)

  suspect_pages (Transact-SQL)

  sys.assemblies (Transact-SQL)

  sys.database_recovery_status (Transact-SQL)

  sys.dm_broker_connections

  sys.dm_db_index_operational_stats

  sys.dm_db_index_physical_stats

  sys.dm_db_mirroring_connections

  sys.dm_exec_cached_plans

  sys.dm_exec_query_optimizer_info

  sys.dm_exec_query_plan

  sys.dm_exec_query_stats

  sys.dm_exec_requests

  sys.dm_exec_sql_text

  sys.dm_os_schedulers

  sys.dm_os_tasks

  sys.dm_os_threads

  sys.dm_os_workers

  sys.dm_tran_active_snapshot_database_transactions

  sys.dm_tran_current_snapshot

  sys.dm_tran_current_transaction

  sys.dm_tran_top_version_generators

  sys.dm_tran_transactions_snapshot

  sys.dm_tran_version_store

  sys.server_event_notifications (Transact-SQL)

  sys.sysindexes (Transact-SQL)

  sys.sysprocesses (Transact-SQL)

  sys.trigger_events (Transact-SQL)

  sys.user_token (Transact-SQL)

  table (Transact-SQL)

  Table Hint (Transact-SQL)

  TOP (Transact-SQL)

  WAITFOR (Transact-SQL)

  xml (Transact-SQL)

Back to Top

Tutorials

• New Topics
  Bike Buyer DMX Tutorial

  Market Basket DMX Tutorial

  Tutorial: Creating a Report Model Based on an Analysis Services Cube

  Tutorial: Creating Model-Based Reports in Report Designer

  Tutorial: Refining a Report Model in Model Designer

  Tutorial: Using XML Data in a Report

• Updated Topics
  Lesson 3: Using the dta Command Prompt Utility

  Lesson 3: Defining a Query for the Report

  Lesson 7: Configuring the Generator and Distributor

  Reporting Services Tutorials

Back to Top

UI Reference

• New Topics
  Check Constraint Expression Dialog Box (Visual Database Tools)

  Color Dialog Box (Visual Database Tools)

  Location Dialog Box (Visual Database Tools)

  Open File, Project, or Solution Dialog Box

  Select Template Name

• Updated Topics
  Activity Monitor (Process Info Page)

  Back Up Database (General Page)

  Browse for Servers (Network Servers)

  Chart Properties (Filters Tab, Report Designer)

  Choose Destination Location (Package Migration Wizard)

  Configure SQL Server Agent Error Logs (General Page)

  Copy Database Wizard (Select a Destination Server)

  Copy Database Wizard (Select the Transfer Method)

  Copy Database Wizard F1 Help

  Credential Properties (General Page)

  Data Conversion Transformation Editor

  Data Region Filters (Report Designer)

  Database Properties (Options Page)

  Dataset (Filters Tab, Report Designer)

  Digital Signing

  Excel Connection Manager Editor

  Excel Source Editor (Connection Manager Page)

  Execute Package Task Editor (Package Page)

  Execute Package Utility F1 Help

  Execute SQL Task Editor (General Page)

  Execute SQL Task Editor (Parameter Mapping Page)

  Execute SQL Task Editor (Result Set Page)

  File System Task Editor (General Page)

  Flat File Connection Manager Editor (Advanced Page)

  Flat File Source Editor (Columns Page)

  Folder Properties (Permissions Page)

  Foreach Loop Editor (Collection Page)

  Fuzzy Lookup Transformation Editor (Reference Table Tab)

  Grouping and Sorting Properties (Filters Tab, Report Designer)

  Linked Server Properties (Security Page)

  List Properties (Filters Tab, Report Designer)

  Maintenance Plan Wizard (Define Shrink Database Task Page)

  Maintenance Plan Wizard F1 Help

  Matrix Properties (Filters Tab, Report Designer)

  Multiple Flat Files Connection Manager Editor (Advanced Page)

  OLE DB Destination Editor (Connection Manager Page)

  OLE DB Source Editor (Connection Manager Page)

  Options (Query Results/SQL Server/Results to Grid Page)

  Options (Text Editor/All Languages/General Page)

  Report Properties (References Tab, Report Designer)

  Select a Dimension Table and Keys (Slowly Changing Dimension Wizard)

  Select Configuration Type (Package Configuration Wizard)

  Select Source Tables and Views (SQL Server Import and Export Wizard)

  Server Properties (General Page)

  SQL Destination Editor (Connection Manager Page)

  Surface Area Configuration for Features (DAC) - Database Engine

  Table Properties (Filters Tab, Report Designer)

Back to Top

WMI Provider for Configuration Management

• Updated Topics
  SetServiceAccountPassword Method (SqlService Class)

  SetStartMode Method (SqlService Class)

  StartMode Property (SqlService Class)

  Working with the WMI Provider for Server Events

Back to Top

See Also

Concepts

New and Updated Topics in Previous Releases of Books Online
New and Updated Books Online Topics (14 April 2006)

Help and Information

Getting SQL Server 2005 Assistance