Programming SQL Server 2005
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] DAT (Database Engine Tuning Advisor) Data Mining Extensions (DMX) 2nd data providers ADO.NET enhancements SQL Server Mobile statistics, retrieving data storage objects, managing data types .NET FOR XML clause large-value SMO classes T-SQL large value xml xml columns instances limitations methods variables data-flow components, SSIS 2nd programming tasks, SSIS data-preparation tasks DataAdapter class Database Diagram Designer Database Diagrams node Database Engine connecting Database Engine Tuning Advisor (DTA) Database Mail, managing Database property Database.Users collection Database_Name parameter DatabaseMapping class DatabaseName property 2nd DATABASEPROPERTYEX function DatabaseRole object databases applications enumerating managing create database template defaults, SMO classes files instances, managing mirroring objects creating enumerating permissions, SMO classes properties, enumerating proxy accounts, creating publication, enabling for references, adding roles, SMO classes SASS querying retrieving schemas schemas, discovery servers, instances SMO classes space, reclaiming SQL Server Mobile creating 2nd managing SqlMail class synonyms tables, checking integrity troubleshooting updating verifying xml data type columns instances limitations methods variables Databases node DataSet class 2nd DataSet objects, filling DataTable class DataTableReader class DbConnectionStringBuilder class DbMetaDataCollectionNames class DbProviderFactory class DDL (Data Definition Language) CLR integration syntax references triggers 2nd SMO classes debugging CLR routines Decision Support Objects (DSO) 2nd DECLARE statement default databases, SMO classes defining contacts polygons schedules UDTs delete statement deleting assemblies databases, SQL Server Mobile endpoints functions indexes stored procedures triggers types UDA functions XML schema collections delivery channels creating DeliveryChannelName property DENSE_RANK( ) function Deny( ) method denying permissions, XML schema collections deployment, SSRS design, CLR integration DestinationDatabase property destinations, SSIS data-flow components development, SASS DeviceAddress property 2nd DeviceName property Devices property DeviceTypeName property Diagram Designer dialog boxes Add Database Reference Add New Item Add Table Alert Properties Edit Filter Instance Properties Job Properties 2nd Job Schedules Properties log File Viewer Login-New New Project Publication Properties 2nd Specify Values for Templates Parameters Subscription Properties dialogs, Service Broker DiffGrams DIGEST authentication type dimension tables 2nd DirectoryEntry class DirectoryLoader class discarding whitespace Disconnect( ) method disconnected class enhancements disconnecting discovery, schemas Distributed Transaction Coordinator, managing DistributionDatabase object DistributionPublisher class Distributor property distributors creating installing DistributorSecurityMode property DML (Data Manipulation Language) triggers SMO classes XML DMX (Data Mining Extensions) 2nd documents DiffGrams XML catalog views columns DML FOR XML clause indexing instances limitations methods relational data variables xml data type XQuery domains, CLR integration design double quotation marks (") DROP AGGREGATE statement DROP ASSEMBLY statement DROP ENDPOINT statement DROP FUNCTION statement DROP INDEX statement DROP PROCEDURE statement DROP TRIGGER statements DROP TYPE statement DROP XML SCHEMA COLLECTION statement Drop( ) method DSO (Decision Support Objects) 2nd DTSConfigurationType enumeration DtsEventHandler class DTSExecStatus enumeration |