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]
caches, GAC
callbacks
capturing statements
CAS (code access security)
CAST function
casting strings
catalog views 2nd
endpoints
messages
sys.assemblies
sys.assembly_files
sys.assembly_modules
sys.assembly_references
sys.assembly_types
XML
xml_indexes
xml_schema_collections
cells
CellSet class
certificates, SMO classes
channels, creating delivery
check constraints, SMO classes
CheckTables( ) method
ChronicleQuantumLimit property
chronicles
events
managing
classes 2nd 3rd 4th
ADO.NET, disconnected enhancements
AdomdCommand
AdomdConnection
AdomdDataReader
CellSet
Configuration
data providers, SQL Server Mobile
DataAdapter
DatabaseMapping
DataSet 2nd
DataTable
DataTableReader
DbConnectionString
DbMetaDataCollectionNames
DbProviderFactory
DirectoryEntry
DirectoryLoader
DistributionPublisher
DtsEventHandler
events
creating
ExceptionMessageBox
HostedEventProvider
instance, instantiation
Job
JobSchedule
JobStep
LogProviders
ManagedComputer properties
MergeArticles
MergePullSubscription
notification
creating
Operator
PrecedenceConstraint
ProxyAccount
RegisteredSubscriber
Server
ServerAlias
ServerConnection
ServerPermission
ServerPermissionInfo
ServerPermissionSet
Service
ServiceBroker
SMO
backup/restore
object model
programming
programming WMI
RegisteredServer
scripting
SqlMail
trace/replay
Transfer
SmoException
SqlBilkCopyColumnMapping
SqlCeEngine 2nd
SqlClientFactory
SqlCommand
SqlContext
SqlDataRecord 2nd
SqlDependency
SqlMetaData
SqlNotificationRequest
SqlPipe
SqlSmoObject
SqlTriggerContext 2nd
SQLXML 4.0
SqlXmlAdapter
SqlXmlCommand
SubscriberDevice
subscriptions
subscriptions, creating
UserDefinedFunctions
XmlReader, retrieving objects
clauses
.WRITE
AS SNAPSHOT
AUTHENTICATION
EXECUTE AS
FOR XML 2nd
OUTPUT
TABLESAMPLE
TOP
WHERE
operators
clients
SQL Native Client, programming
SQL Server Mobile
SQLXML 4.0
annotated mapping schemas
DiffGrams
managed classes
template queries
UpdateGrams
XML result sets, processing
CLR (Common Language Runtime)
.NET data types
ADO.NET in-process extensions
assembly management
custom attributes
DDL
debugging/testing
design
enabling
Hello World example
required .NET namespaces
routines
stored procedures
triggers
UDA functions
UDFs
UDTs
code access security (CAS)
CODEPAGE
collections
Database.Users
hierarchies, iterating
iterating
ServiceBroker class
XML schemas, managing
colName
colPattern
colType
columnName
columns
bulk copy format files
query statistics
SMO classes
statistics, viewing
XML
bulk loading data
indexing
xml data type
command-line compilers
command-line utilities
SSIS
commands
MARS
parameter values
CommandType property 2nd
CommitPropertyChanges( ) method
Common Model, ADO.NET
common table expressions (CTEs)
Compact( ) method 2nd
comparing scalar values and result sets
compilers, command-line
components
data-flow 2nd
SQL Native Client
ConfigString property
configuration
alerts, SQL Server Agent
applications, Notification Services 2nd
articles
classes
notification
subscriptions
content formatters
contracts, Service Broker
databases
objects
SQL Server Mobile 2nd
xml data type
delivery channels
distributors
events
classes
providers
generators
instances, Notification Services
jobs, SQL Server Agent
native XML web services
operators, SQL Server Agent
packages 2nd
permissions 2nd
protocols, notification
proxy accounts, SQL Server Agent
publications
publishers
queries
queues, Service Broker
relationships
replication prerequisites
routes, Service Broker
schedules, SQL Server Agent
servers
aliases
SMO classes
SMO applications (in Visual Studio.NET)
SQL Server Configuration Manager
SQL Server Management Studio
SQL Server Surface Area Configuration
subscribers
subscriptions 2nd
traces
vacuum schedules
Configuration class
ConfigurationType property
CONNECT permission
Connect( ) method
ConnectionContext property 2nd
connections
databases, schema discovery
management
adding
SSIS
MARS
Object Explorer
permissions
ServerConnection object
SQL Server Mobile
strings
adding
retrieving
tasks
ConnectionSecurityContext object
ConnectionStrings( ) method
constants, assigning
constraints
modifying
precedent, SSIS
ContactNotification service
contacts, defining (SQL Server Agent)
containers
databases, SASS
For loops
Foreach loops
sequence
SSIS
control-flow elements
precedent constraints
content formatters
creating
managing
contracts, Service Broker 2nd
creating
control-flow
elements, SSIS
programming
controls, ReportViewer
conversations, Service Broker
CONVERT function
CopyAllTables property
CopyData property
copying
bulk copy (ADO.NET)
schemas
CopySchema property
CREATE AGGREGATE statement
CREATE ASSEMBLY statement
CREATE DATABASE T-SQL statement
create database template
CREATE ENDPOINT statement
CREATE ENDPOINT T-SQL statement
CREATE FUNCTION statement
CREATE INDEX statement
CREATE PROCEDURE statement
CREATE statement
CREATE TABLE statement
CREATE TRIGGER statement
CREATE TYPE statement
CREATE XML SCHEMA COLLECTION statement
Create( ) method
CreateDataReader( ) method
CreateDistributor( ) method 2nd
CreateEventClass( ) method
CreateGenerator( ) method 2nd
CreateHostedEventProvider( ) method
CreateNotificationClass( ) method
CreateParameter( ) method
CreateSubscriber( ) method 2nd
CreateSubscription( ) method
CreateSubscriptionClassMethod( ) method
CreateSyncAgentByDefault property
CreateVacuumSchedule( ) method
credentials
Security node
SMO classes
CTEs (common table expressions)
cubes, SASS
Current property
customizing attributes, CLR routines
|
Ajax toolkit
Ajax tutorials