C

C# projects

defining GetSalespersonCount method in, 74

using .NET data providers with, 72

Cancel system variable, purpose in Integration Services, 195

catalog security, overview of, 21

catalog views, availability in SQL Server Service Broker, 140

certificate-based authentication, using with dialogs in SQL Server Service Broker, 139

Chart control, using with Report Designer, 166

Choose the Table Style window, displaying in Report Wizard, 180

Chronicles section, using with ADF event schema, 115

classes, using in Notification Services, 124

CLR (Common Language Runtime), overview of, 68–69. See also .NET CLR

CLR database objects

creating, 69, 72

guidelines for use of, 89

CLR security, overview of, 89

CLR triggers, creating manually, 79–80

CLR user-defined data types, creating, 80–85

clustering

versus Database Mirroring, 55

setting up, 51

Clustering algorithm, relationship to data mining, 238

columns. See also non-key columns

creating with UDTs, 85

creating with varchar(max) data type, 95

and data partitioning keys, 11–12

displaying for queries in Report Wizard, 180

selecting with Query Builder, 178

using XML data types with, 143

command-line switches, using with Sqlcmd, 39

complex flow control, support in Integration Services, 196–197

components, manipulating with Toolbox in Report Designer, 165–166

Computer Manager. See SQL Server Computer Manager

configuration, improvements to, 61

configuration files, creating for Notification Services application, 111–113

configuration options, using with SQL Server Service Broker, 138–140

config.xml ACF file, code for, 112–113

Connection Manager, using with Data Flow Designer, 208

connection strings, significance in ADO.NET’s asynchronous queries, 99

containers

role in DTR, 191–192

using in Integration Services, 196–197

using with Integrated Services, 198–199

ContentFormatter element of ADF, description of, 120

continue past restore errors feature, support for, 63

contracts

creating for SQL Server Service Broker application, 134

using with SQL Server Service Broker, 132

Control Flow Designer, using with Integration Services, 207

CONTROL permission, description of, 20

conversation groups, relationship to SQL Server Service Broker, 129–130

CountDone system variable, purpose in Integration Services, 195

CREATE AGGREGATE statement, example of, 88

CREATE ASSEMBLY command

loading assemblies with, 69

naming assemblies with, 74–75

reloading DLLs with, 77

CREATE DATABASE DDL statements, using with Database Snapshots, 56

CREATE FUNCTION statements, creating UDFs with, 77

CREATE ROUTE statements, using with SQL Server Service Broker application, 135

CREATE SERVICE statements, using with SQL Server Service Broker application, 135

CREATE TABLE statements

using with data partitioning, 11

using with strongly typed XML data types, 145

Create Trace Wizard feature of Profiler, description of, 45

CREATE TRIGGER state, example of, 79–80

CREATE TYPE statements, using with UDTs, 84

CREATE XML SCHEMA T-SQL DDL statement, example of, 144

CREATE* T-SQL DDL statements, descriptions of, 133

CreationDate system variable, purpose in Integration Services, 195

CreatorComputerName system variable, purpose in Integration Services, 195

CreatorName system variable, purpose in Integration Services, 195

CTEs (common table expressions), T-SQL support for, 90–91

Cube Browser, using with Analysis Services, 232–233

Cube Editor, using with Analysis Services, 230–232

Cube Wizard, using with Analysis Services, 228–230

cubes, relationship to OLAP, 217

Current Activity window in SQL Server Management Studio, features of, 33

CustomEventDescription system variable, purpose in Integration Services, 195

CustomEventGUID system variable, purpose in Integration Services, 195

CustomEventInfo system variable, purpose in Integration Services, 195

CustomEventName system variable, purpose in Integration Services, 195

CustomEventValue system variable, purpose in Integration Services, 195