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] 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 |