C



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



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

Similar book on Amazon

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