D



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



Programming SQL Server 2005
Programming SQL Server 2005
ISBN: 0596004796
EAN: 2147483647
Year: 2007
Pages: 147
Authors: Bill Hamilton

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net