Index

A

Abort method

AbstractCollectionBase property

Access

   client

   in-process. See In-process data access

   security for

   tracing. See Tracing data access

Access control lists (ACLs)

Access modifiers

Accessors in XQuery

Account Lockout Duration setting

Account Lockout policies

Account Lockout Threshold setting

Accumulate method

ACID properties in transactions

ACLs (access control lists)

Activation in service programs

Active Directory Users and Computers tool

Activity Monitor

Add Database Reference dialog box

Add Reference dialog box

   for SMO projects

   for Visual Studio

Add Table dialog box

Add Web Reference wizard

   for Visual Studio

   for Webmethods

   for WSDL

Addition

   in LDim

   in SqlTypes

ADDR_TAB data type

ADDRESS data type

ADDRESS option for routes

AddSubscriber method

AddSubscriberDevice method

AddSubscription method

AddUser function

ADFs (application definition files)

Adjacent Broker Protocol

ADO

   vs. SMO

   UDTs in

   for XDR schemas

   XML data type in

ADO.NET API

   best practices

   multiple active resultsets in

   SqlClient in. See SqlClient

   UDTs in

   XML data type in

AdoNetDiag

Advanced Data Tablegrams (ADTG)

after keyword

Aggregate functions

   with PIVOT

   user-defined

     best practices

     creating

     implementing

   in XQuery

Aggregate method

Aggregate partitions

Alerts provider

Alias types

ALLOW_SNAPSHOT_ISOLATION option

AllowPartiallyTrustedCallers attribute

ALTER ASSEMBLY statement

ALTER AUTHORIZATION statement

ALTER CERTIFICATE statement

ALTER DATABASE statement

ALTER ENDPOINT statement

ALTER LOGIN statement

Alter method

ALTER QUEUE statement

ALTER ROUTE statement

ALTER TRACE permission

ALTER TRIGGER statement

ALTER XML SCHEMA COLLECTION statement

AlterImpl method

Analysis Services event provider

Anchors in recursive queries

ANSI SQL standard compliance for XML

ANY direction for contracts

APIs

AppDomains

   loading

   protection by

   threads in

   unloading

AppendToFile option

Appids

Application definition files (ADFs)

Application roles

<Application> section

ApplicationDefinitionFilePath entry

ApplicationDefinitionFileSchema.xsd schema

ApplicationName entry

Applications

   critical

   hosting. See Hosting

   messaging

   service-oriented. See Service-oriented database applications

APPLY operators

<Arguments> node

Array data type

ArrayList class

as first keywords

as last keywords

AS HTTP clause

AS TCP clause

ASIN function

ASP.NET

   for notifications

   SqlCacheDependency class in

   for streams

   for Webmethods

Assemblies

   altering

   AppDomains for

   code access security for

   dependencies in

   dropping

   loading

   ownership of

   permissions for

   runtime hosting for

   SGen for

   SMO

   storing

Assembly language

AssemblyInfo.cs module

AssemblyName property

Asymmetric keys

Asynchronous messages

Asynchronous support in ADO.NET

ATLTRACE macro

Atomic values in XQuery

Atomicity in ACID properties

Attach to Process dialog box

Attribute-centric mapping in XML

Attributes

   in complex types

   dangerous

   for stored procedures

   for UDTs

   in Visual Studio

   in XML

   in XQuery

Audit object

AUTHENTICATE privilege

Authentication

   in security process

   for SMO connections

   for Web services

AUTHORIZATION parameter

AUTO mode for XML

AutoCreatedLocal route

AutoDisconnectMode property

Automatic operations

   SMO connections

   Visual Studio deployment

Autonomous transactions

AVG function

Axes in XQuery

B

BackgroundWorker class

Backup object model

BadInsert stored procedure

Base class libraries (BCLs)

   in exceptional handling

   loading

Base classes in ADO.NET

BaseDirectoryPath entry

Basic authentication

Batch processing

   batch-enabled Web Services

   in Service Broker

   in SQL

BatchCommands element

BCLs (base class libraries)

   in exceptional handling

   loading

BCP utility

before keyword

BEGIN CATCH statement

BEGIN CONVERSATION TIMER statement

BEGIN DIALOG CONVERSATION statement

   for broker instances

   contracts in

   for conversation groups

   for endpoints

   formats in

   for lifetime

BEGIN TRANSACTION statement

BEGIN TRY phrase

BeginCriticalRegion method

BeginExecuteReader method

BeginTransaction method

Behaviors for types

Benchmarks

Best practices

   service-oriented database applications

   transactions

   XML DML

BINARY data type with XML

Binary representation

   byte order in

   of dates

   IBinarySerialize

   in LDim data type

Binding problems

Bit data type

BizTalk program

BLOB data type

Blocking points in thread scheduling

Bodies in XQuery

BOOLEAN data type

   inclusion of

   for XQuery functions

Broker instances

Broker_Queue_Disabled event

Buffer pools

Bulk import in SqlClient

BULK INSERT statement

Bulk load

   in SQLXML

   in XML

BULK Provider

Business Intelligence Development Studio

Business transactions

   compensation in

   contracts in

   conversation groups in

   conversations in

   distribution in

   message types in

   poison messages in

   processing loops in

   send types in

   service programs

Byte ordering

C

C# language, null values in

Cache class

Cached execution plans

CacheDependency class

Caches

   DataSet

   dispatching notifications to

CalculateCipherLen function

Cancel method

CapturedSql property

Cartesian products

Case-sensitivity

   in CLR

   in XQuery

CAST operator

   in SqlTypes

   for UDTs

   in XML

Casting functions in XQuery

Categories

   metadata

   security

CEILING function

Certificates

   in code signing

   in encryption

Chaining, ownership

ChangePassword method

   in ServerConnection

   in SqlConnection

CHAR data type

   in messaging applications

   in SqlTypes

   in Visual Studio

   in XML

Character-based data types in XML

Charts of accounts

CHECK constraints

CHECK_EXPIRATION option

CHECK_POLICY option

CheckDirectInput method

CheckRangeAndAccuracy method

Child axes in XQuery

Children in DependencyTree

<ChronicleRule> node

Chronicles and chronicle tables

CIM (Common Information Model) repository

Class Library project type

Classes

   in CLR type system

   loading

   nesting

   visibility of

Clients

   best practices

   data types for

   database access by

   encryption support in

   failover support in

   large value data types on

   multiple active resultsets in

   native

   password change support in

   Query Notification support in. See Query Notification support

   stored procedures in

   transactions in

   UDTs for

     from DataReaders

     .NET Framework

     in ODBC, OLE DB, and ADO

   XML data type on

     in ADO

     in ADO.NET

     documents, fragments, and FOR XML support

     as string

CLOB data type

Close method

CLR (Common Language Runtime) languages

   for extensions

     basics

     details

   hosting feature in

   parameters and return values in

   SqlTypes in

   stored procedures in

   string operations in

   table-valued functions in

   triggers in

   type system in

     classes

     instances

     namespaces

     visibility

   user-defined functions in

CLS (Common Language Specification)

cmdlets

CoCreateInstance method

Code

   access security

   executing

   loading

   safe

   signing

COLLATE keyword

Collect method

COLLECTION metadata information

COM (Component Object Model)

Comma-separated-value (CSV) files

Command class for providers

CommandNotification keyword

CommandStream property

CommandText property

   in DeleteCommand

   in SqlCommand

comment function

COMMIT statement

Common class for providers

Common Information Model (CIM) repository

Common Language Runtime. See CLR (Common Language Runtime) languages

Common Language Specification (CLS)

Common namespace

Common object request broker architecture (CORBA)

Common table expressions (CTEs)

   in recursive queries

   working with

Common Type System (CTS)

CompareAllSearchableValues option

CompareRowVersion option

Comparisons

   in LDim

   in SqlTypes

   UDTs

   in XML

   in XQuery

Compensation in transactions

Compilation

   Just-In-Time

   statement-level

Complete method

Complex data types

ComplexNumber data type

Component Object Model (COM)

ComposeTx method

Composing transactions

Composition functionality

Concatenation

Concurrent transaction processing

Condition action

Condition class

Configuration

   for Notification Services

   for SMO

   for SSMS

ConfigurationFileSchema.xsd schema

ConflictOption property

Connect method

Connect to Server dialog box

ConnectAsUser property

Connection class

connection strings

ConnectionContext

ConnectionInfo assembly

Connections

   for in-process data access

   for providers

   in SMO

     automatic

     default Windows credentials

     managing

     Runas utility

     SQL Server login

     Windows identity impersonation

   in SSMS

   in Web Services

ConnectionStringBuilder class

ConnectionStrings collection

ConnectionStringSettings class

ConnectionStringsSettingsCollection class

Consistency in ACID properties

Constraints in XML

Constructors

   defined

   in XQuery

Content formatters

CONTENT keyword for schema collections

ContentFormatter node

Context functions in XQuery

Contexts, execution

   for procedural code

   in security

Contracts

   in business transactions

   in messaging applications

conversation_group_id

Conversation groups

Conversation handles

   in business transactions

   in message processing

conversation_id

Conversation timers

Conversations

   in business transactions

   in messaging applications

Conversions

   for messages

   SqlString

   SqlTypes

   XML

CONVERT function

   for messages

   for XML

Cookies

   with EXECUTE AS

   for sp_unsetapprole

Cooperative thread scheduling

CORBA (common object request broker architecture)

CorBindToRuntimeEx method

Correlating messages

CORRESPONDING BY clause

COUNT function

COUNT_BIG function

Counters in SNAPSHOT isolation

CREATE AGGREGATE statement

CREATE APPLICATION ROLE statement

CREATE ASSEMBLY statement

   permissions for

   security levels in

   for SGen assemblies

CREATE ASYMMETRIC KEY statement

Create command in NSControl

CREATE CONTRACT statement

CREATE ENDPOINT statement

   for batches

   for declarations

   sections for

   security for

   for sessions

   SSL for

   for state

   system views for

   URL for

   for Web services

   for Webmethods

CREATE EVENT NOTIFICATION statement

CREATE FUNCTION statement

CREATE LOGIN statement

CREATE MASTER KEY statement

CREATE MESSAGE TYPE statement

Create method

CREATE PROCEDURE statement

CREATE QUEUE statement

CREATE ROLE statement

CREATE ROUTE statement

CREATE RULE statement

CREATE SCHEMA statement

CREATE SERVICE statement

CREATE SYNONYM statement

CREATE TABLE statement

   for Event Notifications

   ON DELETE and ON UPDATE clauses

   for schemas

CREATE TRIGGER statement

CREATE TYPE statement

CREATE USER statement

CREATE VIEW statement

CREATE XML SCHEMA COLLECTION statement

CreateCommand method

CreateImpl method

CreateReader method

Credentials

Critical applications

CriticalFinalizerObject class

CROSS APPLY operator

   for joining sets

   for nodes

CSV (comma-separated-value) files

CTEs (common table expressions)

   in recursive queries

   working with

CTS (Common Type System)

Current property

   in IEnumerator

   in Transaction class

Cursorless mode in clients

D

Dangerous attributes

Data accessor functions in XQuery

Data Definition Language (DDL) statements

   for code loading

   triggers in

Data Links API

Data manipulation language (DML)

Data protection API (DPAPI)

Data providers

Data source enumerations

Data Source property

Data type compatibility mode

Data types

   for clients

   defined

   SqlTypes

   SQLXML

   user-defined. See User-defined types (UDTs)

   Visual Studio

   XML. See XML and XML data type

   in XQuery

   in XSD

DataAccess property

DataAccessKind attribute

DataAdapter class

Database Lister application

Database master keys

Database Object Explorer

Database transactions

DatabaseCollection class

DatabaseOptions

Databases property

DataColumns

DATALENGTH function

DATALINK data type

DataReader class

   for providers

   UDTs from

DataRows

DataSet class

DataSourceInformation collection

DataTables

DataTypes metadata category

Dates

   representation of

   in XML

DATETIME data type

db_owner role

DBCC CHECKTABLE command

DbCommand class

DbCommandBuilder class

DbConnection class

DbConnectionStringBuilder class

DbDataReader class

DbDataSourceEnumerator class

DBDROPSET_SS_ROWSET property

DbMetaDataCollectionNames class

DbMetaDataFactory class

dbo.find_expensive stored procedure

DbParameter class

DBPROPSET_SQLSERVER_PARAMETERS property

DbProviderFactories class

DbProviderFactory class

DBSCHEMA_COLUMNS property

DBSCHEMA_PROCEDURE_PARAMETERS property

DBSCHEMA_SQL_ASSEMBLIES property

DBSCHEMA_SQL_ASSEMBLY_DEPENDENCIES property

DBSCHEMA_SQL_USER_TYPES property

DBSCHEMA_XML_COLLECTIONS property

DBTYPE_BYTES data type

DbType class

DBTYPE_UDT data type

DBTYPE_WSTR data type

DBTYPE_XML data type

DCOM systems

DDL (data definition language) statements

   for code loading

   triggers in

DDL_DATABASE_LEVEL_EVENTS hierarchy

Deadlock errors

Debugging

   parameter binding problems

   in Visual Studio

DECIMAL data type

   precision of

   in Visual Studio

   in XML

Declarations

   endpoint

   property

Declarative transactions

Decomposition functionality

DecryptByKeyAutoCert function

DEFAULT contracts

DEFAULT message type

DEFAULT_SCHEMA keyword

Default Windows credentials connections

DefaultConnection program

DefaultSMOConnection program

Deferred processing in messaging

DEFINITION_SCHEMA for metadata

DeKlarit tool

DELETE permission

DELETE statement

   CTEs with

   OUTPUT clause in

   TOP clause in

   in XML

DeleteCommand command

DELETED table

Deleting reservations

Delivery of Notification Services

   channels for

   customizing

   protocols for

DeliveryChannelName property

DeliveryChannels entry

<DeliveryChannels> node

DENSE_RANK function

Dependencies

   in assemblies

   in scripts

DependencyTree class

DependencyTreeNodes class

Deployment in Visual Studio

Derivation by restriction process

Descendant axes in XQuery

Descendant-or-self axes in XQuery

Describe packets for metadata

Design patterns for Notification Services

Destructors

Deterministic functions

Development languages

DeviceAddress property

DeviceName property

Devices for Notification Services

DeviceTypeName property

Dialogs in Service Broker

Digest delivery

Dimensions for scalars

Dimensions namespace

Dirty property

DISABLE LOGIN statement

DISABLED option for batches

DISABLED state for endpoints

Disconnect method

DisconnectIfPooled property

Dispatching notifications

Dispose method

   in IDisposable

   in TransactionScope

   in XmlReader

Disposing objects

DISTINCT keyword

Distinct types

Distributed processing

Distributed systems

Distributed transaction coordinator (MSDTC)

Distributed transactions

Distribution in business transactions

Distributor node in ADFs

Distributors in Notification Services

DLINQ language

DLLs (Dynamic Link Libraries)

dm_qn_subscriptions view

DML (data manipulation language)

DMVs (dynamic management views)

Document fragments

DOCUMENT keyword for schema collections

Document Object Model (DOM)

Document order in XQuery

Document Type Definitions (DTDs)

   for message types

   in well-formed documents

Documents with XML data type

DOM (Document Object Model)

Domain-neutral code

Domain-specific aggregate functions

DoWork method

DPAPI (data protection API)

DROP ASSEMBLY statement

DROP ENDPOINT statement

Drop method

DROP ROUTE statement

DROP TABLE statement

DROP TYPE statement

DROP XML SCHEMA COLLECTION statement

DropImpl method

Drops object

DTDs (Document Type Definitions)

   for message types

   in well-formed documents

DUMPBIN.EXE tool

dumpfile.csv file

Durability in ACID properties

Dynamic Link Libraries (DLLs)

Dynamic management views (DMVs)

E

Eager notifications

Element-centric mapping

Elements in XML

ELEMENTS XSINIL directive

EmployeeRoutines library

EMPTY validation

Enable command in NSControl

ENABLED option for batches

Encryption

   functions for

   keys for

   in SQL Server login

END CATCH phrase

END CONVERSATION statement

END TRY phrase

End users, dispatching notifications to

EndCriticalRegion method

EndDocument method

EndExecuteRead method

Endianness

Endpoints

   in HTTP

     creating

     declaring

     metadata

     in SQLXML

     SSL for

     states

     system views for

     URL

   in message conversations

EnterpriseServices library

Entitized XML

ENTITYs for message types

Enumerating data sources

Enumerator methods

Equals method

.err extension

Error class

error function

ERROR_LINE function

ERROR_MESSAGE function

ERROR_NUMBER function

ERROR_PROCEDURE function

ERROR_SEVERITY function

ERROR_STATE function

@@ERROR variable

Errors

   with conversations

   messages for

   in .NET Framework

   in T-SQL

ErrorTestW stored procedure

ETW (Event Tracing for Windows) provider

Event-driven subscriptions

Event Notifications

Event property in SqlTrigger

Event Tracing for Windows (ETW) provider

EventClass node

EventClasses

EventClassName argument

EVENTDATA function

EventRule element

<EventRules> node

Events

   defined

   for Notification Services

     chronicles for

     classes for

     providers for

     rules for

     stored procedures for

   for queues

   SSB service for

EventsData.xml file

EWT (Event Tracing for Windows) provider

EXCEPT operator

Exception class

Exception handling

   in hosting

   for in-process data access

   in T-SQL

ExceptionThrower method

Executable (EXE) files

EXECUTE AS clause

EXECUTE permission

   for assemblies

   for schema collections

   for stored procedures

   for UDTs

Execute Procedure dialog box

ExecuteAndCaptureSql property

ExecuteAndSend method

ExecuteNonQuery method

ExecuteReader method

ExecuteScalar method

ExecuteSql property

ExecuteXmlReader method

Executing code in Visual Studio

Execution contexts

   for procedural code

   in security

Execution plans

exist method

EXISTS operator

exit function

Expensive property

Expiration time for notifications

Expired passwords

Explicit data type conversions

EXPLICIT mode for XML

Explorer tree

Expressions

   CTEs

     in recursive queries

     working with

   FLWOR

   regular

   in XPath

Extended data types

Extended functions

Extended stored procedures

Extensible Stylesheet Language Transformations (XSLT)

EXTERNAL_ACCESS security level

   for assemblies

   attributes disallowed by

EXTERNAL NAME clause

   parts of

   for triggers

   for UDTs

F

Facets

Factories

   in ADO.NET

   provider

Failover support

Failure escalation policy

Fibers in runtime hosting

Fiddler tool

Field Object Properties collection

Fields

   defined

   in UDTs

File protocol

File provider

File Watcher event provider

FileSystemWatcher class

FileSystemWatcherProvider class

Fill method

FillPropertyList method

FillRowMethod method

FillRowMethodName property

FilterCallbackFunction function

Final queries

Finalization, object

Finalize method

Finalizers in exceptional handling

finally blocks

   in exceptional handling

   in T-SQL

Firehose mode

Firewalls

Fix points in recursive queries

Float data types

FLWOR expressions

fn:collection function

fn:doc function

FOR clause

   in FLWOR expressions

   in PIVOT

   in UNPIVOT

   in XQuery

FOR PATH clause

FOR PROPERTY clause

FOR SOAP clause

   for batches

   for endpoints

   for rowsets

   WSDL option in

FOR VALUE clause

FOR XML clause

   for inline XSD format schema

   for nested XML queries

   for NULL values

   for root elements

   support for

   with UDTs

   for whitespace entitization

   for XML data types

   XMLSCHEMA version

FOR XMLAUTO clause

FOR XML EXPLICIT clause

FOR XML PATH clause

FOR XML RAW clause

force flag in Update

FOREIGN KEY clause

Format.Native implementation vs. Format.UserDefined

FORMAT option for WEBMETHOD clause

Format property in SqlUserDefinedType

Formatters for Notification Services

Forward-only mode

Fragments

FROM clause in FLWOR expressions

FROM OPENROWSET clause

FROM SERVICE clause

   for messaging applications

   for queues

FromBytes method

Functions

   aggregate. See Aggregate functions

   CLR

     table-valued

     user-defined

   deterministic

   XML

   XQuery

FX libraries

G

GAC (global assembly cache)

Garbage-collected heap

Garbage collection

GC class

GenerateRepairWSDL function

<Generator> node

Generators in Notification Services

Geographic Information Systems (GIS)

GET command

GET CONVERSATION GROUP statement

get-member cmdlet

get method

GetBits method

GetBytes method

   in SqlDataReader

   for UDTs

GetChars method

GetCLRControl method

GetCLRManager method

GetColumnInfo method

GetColumnsRowset method

GetConnectionBaseClass2 method

GetConnectStringFromConfigFile method

GetDataSources method

GetDecimal method

GetEstimate method

GetEstimateResponse method

GetFactory method

GetFactoryClasses method

GetHashCode method

GetHostManager method

GetInitializedConnectionBaseClass method

GetJobs method

GetKeys method

GetListOfTables method

GetOuterXml method

GetParameterProperties method

GetPropertyObject method

GetProviderFactoryFromUserInput method

GetProviderFromConfigFile method

GetProviderSpecificFieldType method

GetProviderSpecificValue method

GetPubAuth stored procedure

GetResult method

GetRow method

GetScaled method

GetSchema method

   in IXmlSerializable

   in LDim

   for metadata

   for restrictions

   in SqlConnection

   for table lists

GetSchemaRowset method

GetSchemaTable method

GetSmoObject method

GetSqlBinary method

GetSqlBytes method

   in SqlDataReader

   for UDTs

GetSqlChars method

GetSqlDecimal method

GetSqlString method

GetSqlXml method

GetType method

GetValue method

   in IDataRecorder

   in SqlDataReader

GetValues method

GetWSDLUrl function

GetXmlReader method

GIS (Geographic Information Systems)

Global assembly cache (GAC)

Globally Unique Identifiers. See GUIDs (Globally Unique Identifiers)

GRANT statement

GRANT CONNECT statement

GRANT CREATE XML SCHEMA COLLECTION TO statement

GRANT permission

Granting permissions

GROUP BY clause

   with aggregate partitions

   with XML

Groups

   conversation

   Windows

Guest user

GUIDs (Globally Unique Identifiers)

   for assemblies

   for brokers

   for conversation endpoints

   for conversation groups

   for messaging applications

   for providers

   for routes

H

HasRows property

   in DataReader

   in DbDataReader

Helper functions

Hints, query

Host Protection Attributes (HPAs)

<HostedProvider> node

Hosting

   AppDomain loading for

   assemblies in

     dependencies

     maintenance

     storing

   code loading in

   exception handling in

   .NET Framework

   purpose of

   resource management for

   safe code in

   security in

   specification compliance in

HostProtectionAttribute class

Hot-added memory

HPAs (Host Protection Attributes)

HTTP

   endpoints

     creating

     declarations

     metadata

     in SQLXML

     SSL for

     states

     URL

   for Web Services

     basic authentication

     connections

     response

http//www.w3.org/2001/XMLSchemainstance namespace

http//www.w3.org/2001/XMLSchema namespace

HTTP provider

httpcfg utility

HTTPS connections

I

IAlterable interface

IBCPSession interface

IBinarySerialize interface

ICommandStream interface

IContentFormatter interface

ICorRuntimeHost interface

ICreateable interface

IDataReader interface

IDataRecord interface

IDBCommandWithParameters interface

IDbConnection interface

IDbParameter interface

IDeliveryProtocol interface

Identity impersonation in Windows

IDispatch interface

IDisposable interface

IDropable interface

IEnumerable interface

IEnumerator interface

IEventProvider interface

IHttpProtocolProvider interface

IL (intermediate language)

ILDasm.EXE (Intermediate Language Disassembler) tool

IMAGE data type

   in clients

   for LOBs

   vs. MAX

Impersonate method

ImpersonateConnect program

Impersonation of Windows identity

Implicit data type conversions

<import> statement

Importing types into schemas

Imports directive

IN clause

   with PIVOT

   with UNPIVOT

In-process data access

   commands for

   connections for

   exception handling for

   pipes for

   return values for

   rowsets for

   SqlClient for

   SqlContext for

   transactions for

   triggers for

   Web Services from SQLCLR for

   WindowsIdentity for

IncludeIfNotExists property

Index buffers

Indexed views

Indexers for SMO objects

Indexes

   for XML data type

   for XQuery

IndexSqlSchema node

Infinite loops

Info property

Information identification for provider factories

Information property

INFORMATION_SCHEMA

   for assemblies

   for metadata

INFORMATION_SCHEMA.ROUTINES view

Infosets

Inheritance in CLR

Init method

INITIATOR direction for contracts

Injection, guarding against

Inline XSD format schema

Input/output parameters for stored procedures

Input validation

INSERT permission

INSERT statement

   with BULK Provider

   CTEs with

   encryption in

   OUTPUT clause in

   TOP clause in

   in XML

InsertCommand command

INSERTED table

Inserting rows

Instance configuration files

Instance members for user-defined types

InstanceName entry

InstanceName property

Instances in CLR type system

INSTEAD OF triggers

Integral data types in XML

Integrity checking

IntelliSense for SMO

Intermediate language (IL)

Intermediate Language Disassembler (ILDasm.EXE) tool

Internal activation in service programs

Interoperability

   in service-oriented database applications

   with SqlContext

INTERSECT operator

<Interval> element

INTO clause

   with INTERSECT and EXCEPT

   with OUTPUT

   with RECEIVE

   with XML

INullable interface

invariant attribute

Invocation links

InvokeIfReceiverIsNull property

IP addresses

IRowsetFastLoad interface

IS NULL clause

is operator in XQuery

ISAPI application

ISAPI filters

IsAvailable property

IsByteOrdered property

IScheduledEventProvider interface

ISchemaRowset method

IsDeterministic property

IsFixedLength property

IsInvariantToDuplicates property

IsInvariantToNulls property

IsInvariantToOrder property

IsMatch method

IsMutator property

IsNull property

   in LDim

   in SqlChars and SqlBytes

   in SqlTypes

   in UDTs

IsNullable property

   in SqlFacet

   in SqlSmoObject

IsNullIfEmpty property

Isolation

   in ACID properties

   SNAPSHOT

Isolation levels in transactions

IsPrecise property

ISQLServerErrorInfo interface

ISSAbort interface

ISSAsyncStatus interface

ISSCommandWithParameters interface

IsSendingResults method

IsUpdatedColumn method

Item property

Items in XQuery sequences

IUnknown interface

IXmlSerializable interface

J

jar files

Join equivalents in XQuery

Joins with APPLY operators

Just-In-Time (JIT) compilation

K

Kernel

Keyrings

Keys, encryption

KILL command

L

Large object data types (LOBs)

Latitude data type

Lawrence, Eric

Lax validation in XML

LDim data type

   creating

   in DataReader

   helper functions in

   IBinarySerialize for

   implementations in

     binary

     Format.Native vs. Format.UserDefined

     null value

     string

   maintaining

   objects for

   public members in

   source code for

   validation in

   XML with

let keyword

   in FLWOR expressions

   in XQuery

Libraries, loading

Library modules (DLLs)

LIFETIME clause

   for dialogs

   for routes

Lightweight pooling

LinkDemand

Links for assemblies

LINQ language

Load balancing

Loading

   AppDomains

   with BULK Provider

   classes

   code

   XML data

LOBs (large object data types)

Local Security Settings tool

Locality-of-reference choices

LOCATOR data type

Locking

   conversation groups

   in thread scheduling

Logarithms

Login property

Logins

   security for

   for SMO connections

LoginSecure property

logman command

LogRange function

Long-running transactions

Longitude data type

LONGVARBINARY data type

LONGVARCHAR data type

LONGWVARCHAR data type

Lookup tables

Low-memory conditions

M

machine.config file

MakeCall CTE

Managed code

Managed Object Format (MOF) file

ManagedComputer class

Management class

Manifests

Mapping

   in runtime hosting

   schemas

   SQL catalogs and tables

   SQL types

   SqlTypes

   in XML

mapping_schema.xml file

MARS (multiple active resultsets)

   in ADO.NET

   for asynchronous support

   in SQL native client

   with SqlCommand

Marshaling data

Master keys

Match method

Math class

MAX data types

MAX function

MAX_QUEUE_READERS clause

MaxByteSize property

MaximumVersion element

maxInclusive facet

maxOccurs facet

MaxPoolSize property

MAXRECURSION query hint

MaxSize property

MDAC (Microsoft Data Access Components)

Members

MemberwiseClone method

Memory and memory allocation

   for conversations

   hot-added

   in .NET Framework

   out-of-memory conditions

   for runtime hosting

Memory clerk

MERGE JOINs

Merge method

MESSAGE TYPE clause

Messages

   in business transactions

   compensation in

   order of

   poison

   in SSB

Messaging applications

Meta-collections

Metadata

   for assemblies

   for endpoints

   in instance configuration files

   for Notification Services

   in OLE DB

   for rowsets

   in schemas

     availability of

     customizing and extending

     purpose of

   security for

   in SNAPSHOT isolation

MetaDataCollections collection

MetaDataXml attribute

Methods

   defined

   overloading

   in UDTs

Microsoft Alerts provider

Microsoft Data Access Components (MDAC)

Microsoft Data Engine (MSDE)

Microsoft Transaction Server (MTS)

Middle-tier servers

MIN function

minExclusive schema element

MinimumVersion element

minInclusive facet

minOccurs facet

MinPoolSize property

MinutesDelay

MIXED authentication

modify function

   delete

   insert

   replace value of

Modules

MOF (Managed Object Format) file

Monad shell

Monitoring SNAPSHOT isolation versioning

MOVE CONVERSATION statement

MoveNext method

mscoree.dll file

mscorlib.dll file

mscorsvr.dll file

mscorwks.dll file

MSDE (Microsoft Data Engine)

MSDTC (distributed transaction coordinator)

MSN Messenger program

MTS (Microsoft Transaction Server)

Multicast deliveries

Multiple active resultsets (MARS)

   in ADO.NET

   for asynchronous support

   in SQL native client

   with SqlCommand

Multiple Connections property

Multiple-document queries

MUST_CHANGE keyword

Mutators

N

Names and Name property

   for assemblies

   in CLR

   in SqlFunction

   in SqlSmoObject

   in SqlTrigger

   synonyms

Namespace keyword

Namespaces

   CLR

   XML

NaN (not a number) value

Native client

Native XMLWeb Service feature

Navigation in SMO

NCHAR data type

   in messaging applications

   for SqlTypes

   in XML

Nesting

   classes

   transactions

   XML queries

   XML subelements

.NET Framework

   assemblies in

   CLR. See CLR (Common Language Runtime) languages

   members in

   memory management in

   modules in

   runtime hosting

   security for

   SQL Server affected by

   UDTs

     in ADO.NET

     in ODBC, OLE DB, and ADO

NetValidatePasswordPolicy function

New Database Reference dialog box

New Project dialog box

   in SSMS

   in Visual Studio

New Query Editor Window

NextResult method

NGen.exe program

NIH (not invented here) syndrome

1999 Standard

No-namespace schema

node function

Node tables

nodes function

Nodes in XQuery

   comparisons

   functions

   identity

   tests

Non-Uniform Memory Access (NUMA) architecture

NONE validation for message types

<NonHostedProvider> node

NonPooledConnection property

Nonvalidated XML schema

Not a number (NaN) value

Not invented here (NIH) syndrome

Notification Services

   application definition files for

   applications

     coding steps

     generation steps

     planning steps

     sample

   best practices

   components of

   delivery of

     channels for

     customizing

     protocols for

   design patterns for

   distributors and formatters for

   events in

     chronicles for

     classes for

     providers for

     rules for

     stored procedures for

   instance configuration files for

   notifications

   NSControl for

   subscribers

   subscription classes

   subscriptions

   terms for

<NotificationClass> node

<NotificationClasses> node

Notifications

   event

   query. See Query Notification support

NotificationServices.dll file

NotificationServices namespace

NSApplication class

NSBeginEventBatch stored procedure

NSControl tool

NSDeliveryChannels table

NSDiagnosticEventClass stored procedure

NSDiagnosticEventProvider stored procedure

NSEventBatchDetails stored procedure

NSEventFlushBatch stored procedure

NsEventSubmitBatch stored procedure

NSEventWrite stored procedure

NSInstance class

NSNotificationClasses table

NSService process. See Notification Services

nssub class

NSSubscriberChannels table

NSSubscriptionClasses table

NTEXT data type

   in clients

   for LOBs

   vs. MAX

   in XML

NTILE function

NULL constraint

Null instances in SSMS

Null method

NULL values and property

   in FLWOR expressions

   in INTERSECT and EXCEPT

   in INullable

   in LDim

   in ON DELETE and ON UPDATE

   in SqlTypes

   in WSDL

   in XML

Nullable type

NUMA(Non-Uniform Memory Access) architecture

Numeric class

Numeric operators in XQuery

NVARCHAR data type

   in clients

   in MAX

   maximum size for

   in messaging applications

   in SqlTypes

   in SQLXML

   WSDL files for

   in XML

O

Object class

Object data type

Object Explorer

   for SMO object model

   for SSMS

Object Oriented Database Management System (OODBMS)

Object-oriented programming concepts

Object Query Language (OQL)

Objects for UDTs

ObjectType function

ODBC API

   for connection information

   isolation levels in

   .NET Framework UDTs in

   Query Notifications in

Odbc bridge

OLE DB API

   in ADO.NET

   for connection information

   isolation levels in

   .NET Framework UDTs in

   Query Notifications in

OLE DB for Analysis

OleDb bridge

OleDbProviderFactory class

OLTP operations

ON clause for DDL triggers

ON CONTRACT clause

ON CONVERSATION clause

ON DELETE clause

ON UPDATE clause

OnChange event

OnNullCall property

OO4O (Oracle Objects for OLE)

OODBMS (Object Oriented Database Management System)

op_ methods

op_addition operator

op_Equality operator

op_Explicit method

op_Implicit method

op_Inequality operator

Open Data Services API

Open method

OPENROWSET function

OpenXML

operator + method

Operators

   in SqlTypes

   in XQuery

OPTIMIZE FOR clause

Optimizing XQuery queries

OPTION keyword

Optional features, turned off

Options dialog box in SSMS

OQL (Object Query Language)

Oracle Objects for OLE (OO4O)

OracleClient provider

OracleProviderFactory class

ORDER BY clause

   in ranking functions

   in XML

   in XQuery

ORIGINAL_LOGIN function

out modifier

Out-of-memory conditions

OUTER APPLY operator

   for joining sets

   for nodes

OUTPUT clause

Output parameters for stored procedures

OutputCache directive

OutputDebugString system

OVER clause

   for aggregate partitions

   for ranking functions

Overflow conditions, stack

Overloading methods

OverwriteChanges option

Ownership

   of assemblies

   chaining

P

<Parameter> node

<ParameterDefaults> node

ParameterDirection enumeration

Parameterized queries

Parameters

   binding problems

   in CLR

   for scalar user-defined functions

   for SqlCommand

   for stored procedures

   XML for

Parameters element

Parameters property

ParametersCollection

Parent axes in XQuery

Parent-child relationships

Parent navigation in SMO

Parent property

Parents in DependencyTree

Parse method

Partitions

   aggregate

   PARTITION BY clause

Password property

Passwords

   change support for

   for connections

   in HTTP authentication

   policies for

   in ServerConnection

   for SMO connections

   for SQL Server login

PATH indexes

PATH mode

Path value

Pathnames in XML

Paths

   in data tracing

   in HTTP schemes

   in XML

   in XQuery

Pattern-based data types

PERCENT phrase

Performance benchmarks

Performance counters in SNAPSHOT isolation

Performance Logs and Alerts snap-in

PERMISSION_SET clause

Permissions

   for assemblies

   for schema collections

   for security

   for SQLCLR objects

Persistent Stored Modules

PERSON data type

PInvoke

   for interoperability

   for safe assemblies

   for thread scheduling

Pipe property

Pipeline method

Pipes

PIVOT operator

Plan guides and plan forcing

Points

Poison messages

PooledConnectionLifetime property

PopulationMechanism

PopulationString

Ports

   for distribution

   HTTP

   SSL

PORTS option

POST command

Post Schema Validation Infosets (PSVIs)

Precision property

Predicates in XQuery

Preemptive thread scheduling

PrepareCommand value

Primary indexes

PRIMARY KEY option

Principals in security

Principle of least privilege

Private keys

private keyword

Procedural code, execution contexts for

PROCEDURE_NAME clause

Processes in runtime loading

ProcessID property

processing-instruction function

Processing loops in business transactions

Processing messages in SSB

Processing serialization

ProcessObject function

Processors in marshaling data

Product aggregate

Projects

   in SMO

   in SSMS

   in Visual Studio

Prologs in XQuery

Promotable transactions

PromptPassword method

Properties

   defined

   in UDTs

Properties folder

Properties property

PROPERTY indexes

PropertyGrid control

PropertyRetrieved property

<Protocol> node

Protocols for Notification Services

<Protocols> node

ProviderBase namespace

ProviderFactories class

Providers

   in ADO.NET

   in ETW

   factories for

   GUIDs for

   in Notification Services

   SQLXMLOLEDB

<Providers> node

Proxy classes

   WDSL

   Web Service

   Webmethods

PSVIs (Post Schema Validation Infosets)

Public keys

public keyword

Public members in UDTs

public principal

Public-private key pairs

Pulley/belt drive database example

Pulley class

pulley.cs file

PulleyDistance method

PulleyDistanceTSQL function

Q

QNames functions

Quantum for Notification Services

Queries

   hints for

   nesting

   recursive

   SSMS

   statement-level recompilation for

   XPath

     expressions in

     for SMO objects

     in SQLXML

   XQuery. See XQuery query language

Query Designer dialog box

query method

Query Notification support

   from databases

   dispatching in

   eager notifications

   OLE DB and ODBC

   SQL Server 2005

   SqlCacheDependency for

   SqlDependency for

   SqlNotificationRequest for

   usage

Query plans

Query predicates

Query window

QueryMemoryResourceNotification API

QUEUE_ACTIVATION events

Queues

   for messages

   for Query Notifications

   in service programs

QuoteIdentifier property

R

RAISERROR statement

Random samples

Range class

Range errors

RangeFunctions class

RANK function

Ranking functions

RAW mode for XML

RDS (remote data services) architecture

READ COMMITTED isolation level

READ_COMMITTED_SNAPSHOT option

Read method

   in IBinarySerialize

   in LDim

   in SqlDataReader

   in XmlReader

Read-mostly lookup tables

Read-only lookup tables

Read-only mode

READ UNCOMMITTED isolation level

ReadCommitted method

Reader-makeright approach

Readers in SAX

Reading trace output

ReadLine method

READTEXT method

ReadXml method

   in IXmlSerializable

   in LDim

RECEIVE statement

   for conversation groups

   for Event Notifications

   for processing loops

   for queues

Recompilation, statement-level

Recordsets

Recursive queries

REF data type

ref modifier

Reference types

ReferenceEquals method

References folder

REFERENCES permission

   for assemblies

   for schema collections

   for tables

Reflection for assemblies

Regex class

Register command

Registry

   for data tracing

   for provider factories

   for SMO

Regular expressions

Relational data access APIs

Relational databases

Remote data services (RDS) architecture

Remote procedure calls (RPCs)

REMOVE PRIVATE KEY statement

RENAME LOGIN statement

RepairWSDL function

REPEATABLE clause

REPEATABLE READ isolation level

replace value of statement

REPLICATE function

Reporting Services feature

ReportingServices namespace

Reservations for URLs

ReservedWords metadata category

Reset Lockout Counter After setting

Resource management for hosting

Responses for Web Services

Restore object module

RestrictionNumbers

Restrictions, URN retrieval

Restrictions collection

Result method

Results window

Resultsets

Retention for queues

Retrieved property

RetrieveStatistics method

Retry stored procedure

Retrying transactions

return expressions

   in FLWOR

   in XQuery

Return values

   in CLR

   for in-process data access

   for stored procedures

ReturnProviderSpecificTypes property

Reverse method

REVERT statement

Roles

   assigning

   schemas for

ROLLBACK TRAN statement

Rollup accounts

Rollup query

Root elements in XML

Root nodes in XQuery

Routes and routing tables

ROW_NUMBER function

Rows

   inserting

   in SNAPSHOT isolation

ROWS clause

Rowsets

   creating and sending

   watching

   from XML documents

ROWSETS_ONLY option

RPCs (remote procedure calls)

Rules

   creating

   for Notification Services

Rules.dll file

Runas utility

   for ImpersonateConnect program

   for SMO connections

Runtime hosts. See Hosting

S

SAFE security level

   for assemblies

   for hosting

SafeHandle class

Safety levels

Sagas

Sample applications for Notification Services

Samples, random

SAXXMLReader40 class

Scalars

   dimensions for

   points for

   user-defined functions

   user-defined types

ScaleBy method

<Schedule> node

ScheduledRules section

Schema-bound links

Schema node

SchemaFile argument

SchemaGen option

Schemas and schema collections

   in ADO.NET

   for assemblies

   for HTTP

   inline XSD format

   managing

   mapping

   for message types

   metadata in

     availability of

     customizing and extending

     purpose of

   for Notification Services

   security for

   user customization in

   user separation from

   in XML

   in XQuery

SCOPE_IDENTITY function

Script method

Script Stored Procedure As command

ScriptDrops property

Scripter objects

ScriptingOptions object

Scripts

   Object Explorer for

   for SMO

"Sealing the data" process

SecondsDelay data type

Securables

Secure Sockets Layer (SSL)

   encryption in

   for Web Services

SecureString class

Security

   for assemblies

   authentication and authorization in

   best practices

   code signing

   configuring

   encryption for

   execution contexts

     and ownership chaining

     for procedural code

   in hosting

   for metadata

   in .NET Framework

   new features

   optional features in

   password policies and credentials in

   safety levels for

   for schema collections

   separation of users and schemas for

   for SQLCLR objects

   for synonyms

Security Configuration Manager screen

select_and_count stored procedure

SELECT permission

SELECT statement

   CTEs with

   encryption in

   FOR XML clause in. See FOR XML clause

   for queues

   return data from

   in SNAPSHOT isolation

   TABLESAMPLE clause in

   TOP clause in

   vs. XQuery

SelectCommand command

Self axes in XQuery

Self-signed certificates

Semicolons (;)

   for CTEs

   for SSB

"Send a message and go on about your business" technique

Send method

SEND statement

SEND ON CONVERSATION statement

Send type in business transactions

SendResultsEnd method

SendResultsRow method

SendResultsStart method

SENT BY clause

SENT BY ANY clause

SEP (SQL Server event provider)

Separation of users and schemas

Sequences in XQuery

SequentialAccess method

Serializable attribute

SERIALIZABLE isolation level

Serialization

   of DataSets

   IBinarySerialize for

   of transactions

   for UDTs

   in XML

Serialization class

Serialization namespace

Server class

   properties in

   for SMO

Server Explorer

Server Management Objects (SMO)

   vs. ADO

   best practices

   configuration management for

   connections in

     automatic

     default Windows credentials

     managing

     Runas utility

     SQL Server login

     Windows identity impersonation

   object model for

   objects in

     GetSmoObject for

     identity of

     methods of

     parent navigation

     properties for

     state of

     URN retrieval object model

     URN retrieval restrictions

   projects

   purpose of

   scripts for

   Server class for

Server rules

Server Service Broker (SSB) service

   best practices

   business transactions in. See Business transactions

   for events

   message processing in

   for messaging applications

   in Query Notification

Server-side cursors

ServerConnect object

ServerConnection class

   for credentials

   for passwords

   properties of

   for SMO

Service Broker. See Server Service Broker (SSB) service

Service master keys

Service-oriented database applications

   architecture

   best practices

   data models and programming

   new features

   platforms in

   tiers in

Service programs

ServiceMasterKey property

Services

   in messaging applications

   Notification. See Notification Services

   Web. See Web Services

Session keys

SESSION_TIMEOUT clause

SESSIONS clause

set method

SET NEW_BROKER statement

SET ROWCOUNT statement

SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement

Setback field

SetDefaultInitField method

SetFieldValue method

SetHostControl method

SetParameterProperties method

SETUSER statement

SGen utility

   for UDTs

   for XML serialization

SGML (Standard Generalized Markup (Language)

Showplans, XML-based

Shredding XML documents

Signing

   certificates

   code

Simple Mail Transfer Protocol (SMTP)

Simple Message Service (SMS)

Simple Object Access Protocol (SOAP) Protocol

   message format in

   payload format for

   for stored procedure

   for Webmethods

SimpleEnum class

SimpleType class

SINGLE_BLOB keyword

SINGLE_CLOB keyword

SINGLE_NCLOB keyword

SITE option

Skip validation

Sleep method

SMO. See Server Management Objects (SMO)

SMO.dll file

SMO namespace

SmoCollectionBase class

SMS (Simple Message Service)

SMTP (Simple Mail Transfer Protocol)

Snapin for Performance Logs and Alerts

SNAPSHOT isolation level

   in ADO.NET

   versioning in

SNI (SQL Server Network Interface)

SOAP (Simple Object Access Protocol) protocol

   message format in

   payload format for

   for stored procedure

   for Webmethods

SOAP over HTTP

Social Security numbers

Solution Explorer

Solutions in SSMS

Sort Options property

Source property

sp_addapprole stored procedure

sp_addlogin stored procedure

sp_addmessage stored procedure

sp_addtype stored procedure

sp_adduser stored procedure

sp_bindrule stored procedure

sp_bindsession stored procedure

sp_bindtoken stored procedure

sp_delete_http_namepace_reservation stored procedure

sp_grantlogin stored procedure

sp_helptext stored procedure

sp_http_generate_wsdl_defaultcomplexorsimple stored procedure

sp_http_generate_wsdl_defaultsimpleorcomplex stored procedure

sp_lock stored procedure

sp_OACreate stored procedure

sp_reserve_http_namespace stored procedure

sp_setapprole stored procedure

sp_tableoption stored procedure

sp_unsetapprole stored procedure

sp_xml_preparedocument stored procedure

Specialized namespace

Specification compliance in hosting

Specify Values for Template Parameters dialog box

SPIDs (system process identifiers)

Spinlock

SQL BULK INSERT provider

SQL catalogs and tables, mapping to XML

sql:column function

SQL_COPT_SS_MARS_ENABLED option

SQL engine enhancements

   best practices

   BULK Provider

   DDL triggers

   Event Notifications

   large value data types

   plan guides and plan forcing

   query hints

   SNAPSHOT isolation

   statement-level recompilation

SQL_LONGVARBINARY data type

SQL native client

SQL Profiler utility

SQL-PSM queries

SQL Server 1205 errors

SQL Server event provider (SEP)

SQL Server Integration Services (SSIS)

SQL Server login

   encryption support in

   failover support in

   password change support in

   query notifications in

   for SMO connections

SQL Server Management Studio (SSMS)

   configuration

   for Event Notifications

   introduction

   null instances in

   Object Explorer in

   solutions and projects in

   templates in

   for UDTs

   for XML-based showplans

SQL Server Network Interface (SNI)

SQL Server Operating System (SQLOS)

SQL Server Service Broker. See Server Service Broker (SSB) service

SQL Server Surface Area Configuration Utility

SQL_VARBINARY data type

sql:variable function

SQL_VARIANT data type

SQL_WLONGVARCHAR data type

SQL_WVARCHAR data type

sqlBatch element

sqlBatchResponse element

SQLBinary type

SqlBoolean data type

SqlBulkCopy class

SqlBulkCopyColumnMapping class

SqlBulkCopyColumnMappingCollection class

SqlBytes data type

SqlCacheDependency class

SqlChars data type

SqlClient

   ADO.NET with

     asynchronous support

     base classes and factories

     bulk import

     configuration information

     connection strings

     enumerating data sources

     generic coding considerations

     .NET Framework DataSet and SqlDataAdapter enhancements

     provider factories

     schemas

     statistics

     tracing data access

   classes and methods in

   for in-process data access

   for transactions

SqlClient class

SQLCLR

   best practices

   permissions with

   thread synchronization in

   in Visual Studio

   Web Services from

SQLCMD

SqlCommand class

   constructors for

   for MARS

   members of

   return data for

   for SMO

   for UDTs

SqlCommandBuilder class

SqlConnection class

   for client statistics

   for MARS

   members of

   for transactions

SqlContext class

SqlDataAdapter class

   for DataSet upgrading

   enhancements

   for providers

SqlDataReader class

   for clients

   for MARS

   for return data

   with SqlCommand

   UDTs from

SqlDataRecord class

SqlDateTime class

SqlDbType class

   for UDTs

   with large data types

SqlDecimal data type

SqlDependency class

   for Query Notifications

   with SqlCommand

SqlDependency.Start method

SqlDependency.Stop method

SQLDescribeCol class

SqlDouble data type

SqlError class

SqlErrorCollection class

SqlException class

SqlExecutionModes property

SqlFacet attribute

SqlFunction attribute

SqlInt32 data type

SqlMessages element

SqlMetaData class

SqlMetaDataFactory class

SqlMethod attribute

sqlncli.h file

SQLNCLI provider

SqlNotification class

SqlNotificationEventArgs class

SqlNotificationRequest class

SQLNS. See Notification Services

SQLOLEDB provider

SQLOS (SQL Server Operating System)

SqlParameter class

SqlParameterCollection class

SqlPipe class

.sqlplan extension

SqlProcedure attribute

SqlProviderFactory class

SqlQueryNotificationService class

SqlResponseStream scheme

SqlResultCode element

SqlResultStream element

SqlRowCount element

SqlRowSet element

SQLServer class

SqlServerSystem entry

Sqlservr.exe application

SqlSingle data type

SqlSmoObject class

SqlStoredProcedure attribute

SqlString data type

SqlTransaction class

SqlTrigger attribute

SqlTriggerContext class

SqlTypes class

   conversions

   for DataSets

   mapping

   null values in

   parameters and return values in

   working with

SqlUserDefined attribute

SqlUserDefinedAggregate attribute

SqlUserDefinedType attribute

SQLXML

   Bulk Load component in

   data type support in

   features

   .NET Framework for

   operation of

   support for

   XML streams in

SqlXml class

SqlXML element

SqlXmlAdapter class

SqlXmlCommand class

SqlXmlCommandType class

SqlXmlException class

SQLXMLOLEDB providers

SqlXmlParameter class

SSB. See Server Service Broker (SSB) service

SSIS (SQL Server Integration Services)

SSL (Secure Sockets Layer)

   encryption in

   for Web Services

SSMS. See SQL Server Management Studio (SSMS)

SSNRegex function

SSPROP_INIT_MARSCONNECTION property

Stack overflow conditions

Stack walks

Standard Generalized Markup Language (SGML)

Standards in hosting

StartDocument method

STARTED state for endpoints

<StartTime> element

State property

   in Server

   in SqlSmoObject

Statement-level recompilation

Statement-level SNAPSHOT isolation

States, endpoint

Static type checking

Statistics for SqlClient

StatisticsEnabled property

STATUS option for WITH ACTIVATION

Status values for stored procedures

STDEV function

STOPPED state for endpoints

Stored procedures

   in ADO.NET

   attributes for

   in clients

   in CLR

   extended

   for Notification Services

   Object Explorer for

   parameters for

   in T-SQL

   in Visual Studio

   for Web Services

Stream property

Streams in SQLXML

Strict validation

StringCollection class

Strings

   in CLR

   concatenation

   for dates

   in LDim

   in Visual Studio

   in XML

   in XQuery

Strong typing

Strongly typed instances

struct keyword

Structured data types

Structured exception handling

   in hosting

   for in-process data access

   in T-SQL

Subscriber class

SubscriberDevice class

SubscriberId property

Subscribers

Subscription classes

SubscriptionClasses class

Subscriptions

SUBSTRING data type

SUM function

SumLDim function

Summary window

SuppressFinalize method

Surface Area Configuration tool

SUSER_NAME function

Sybase database system

Symmetric keys

Synchronization

   thread

   transaction

Synonyms

sys.assemblies table

sys.assembly_files table

sys.assembly_references table

sys.conversation_endpoints view

sys.conversation_groups view

sys.databases view

sys.dm_clr views

sys.dm_clr_appdomains view

sys.dm_os views

sys.dm_os_memory_clerks view

sys.dm_qn_subscriptions view

sys.dm_tran_ views

sys.endpoints view

sys.http_endpoints view

sys.routes view

sys.soap_endpoints view

sys.transmission_queue system view

sysadmin role

syslogins view

SYSTEM clause

System.Data.dll file

System.Data.OracleClient.dll file

SystemDataAccess property

SystemDataAccessKind attribute

System metadata tables

System process identifiers (SPIDs)

T

T-SQL (Transact-SQL)

   for asynchronous messages

   best practices

   enhancements

     APPLY operators

     CTEs

     error handling

     improvements

     INTERSECT and EXCEPT operators

     ON DELETE and ON UPDATE clauses

     OUTPUT clause

     partitioning

     PIVOT operator

     ranking functions

     recursive queries

     TABLESAMPLE clause

     TOP clause

     UNPIVOT operator

   integration of

   null values in

   for pulley function

   scripts

Table-access links

Table-valued CLR functions

TableCollection class

TableDefinition property

TABLESAMPLE clause

Tabular Data Stream (TDS) protocol

TARGET direction for contracts

Target property

targetNamespace attribute

Task management for runtime hosting

TDS (Tabular Data Stream) protocol

TEMPDB file

Template Explorer

Templates in SSMS

Terminate method

Test Scripts folder

TEXT data type

   in clients

   for LOBs

   vs. MAX

   in XML

text function

TextA event

TextW event

Threads

   in AppDomains

   scheduling

Tiles

TIMEOUT clause

Timeouts for conversations

Timers for conversations

Timestamps in message processing

TNS (transparent network substrate)

TO SERVICE clause

   for broker instances

   for contracts

   for conversations

   for messaging applications

ToBytes method

TOP clause

ToString method

   for DataSet serialization

   in LDim

   in Object

   overriding

   for UDTs

     from DataReaders

     in ODBC, OLE DB, and ADO

TPC-C (Transaction Processing Performance Council benchmark C) benchmark

Tracepoints

tracerpt command

Tracing data access

   application choices for

   basis of

   CSV files for

   ETW in

   for parameter binding problems

   reading output in

   running

   setting up

   user data in

Transact-SQL. See T-SQL (Transact-SQL)

transaction.h file

Transaction-level SNAPSHOT isolation

Transaction library

Transaction Processing Performance Council benchmark C (TPC-C) benchmark

TransactionRequired attribute

Transactions

   autonomous

   best practices

   business. See Business transactions

   declarative and promotable

   distributed

   for in-process data access

   isolation levels in

Transactions library

TransactionScope class

   for distributed transactions

   for promotable transactions

   SqlConnections in

TransactionScopeOption

Transparent network substrate (TNS)

TreeMember method

TriggerContext property

Triggers

   in CLR

   DDL

   for in-process data access

TrustServerCertificate parameter

TRY/CATCH blocks

TryParse method

Tuples

Type property

   for SMO objects

   in SqlNotificationEventArgs

TYPE qualifier FOR XML

Typed XML

Types

   for clients

   defined

   SqlTypes

   SQLXML

   user-defined. See User-defined types (UDTs)

   Visual Studio

   XML. See XML and XML data type

   in XQuery

   in XSD

U

UDDI (Universal Description, Discover and Integration) servers

UDTs. See User-defined types (UDTs)

UNCHECKED DATA option

Undo method

Unicode strings

Uniform Resource Names (URNs)

   retrieval restrictions

   for SMO object identity

UNION ALL operator

UNION queries

UNIQUE constraints

UNIQUEIDENTIFIER class

   for broker instances

   for conversation groups

   for messaging applications

Units of work

Universal Description, Discover and Integration (UDDI) servers

UNPIVOT operator

UnquoteIdentifier property

UNSAFE ASSEMBLY permission

UNSAFE security level

   for assemblies

   finalizers in

Untyped XML

Update command

UPDATE permission

UPDATE statement

   CTEs with

   OUTPUT clause in

   TOP clause in

UpdateBatchSize method

UpdateCommand command

UPDATETEXT method

Updating XML columns

URLs

   ACL for

   endpoint

   reservations for

   for Web Services

URNs (Uniform Resource Names)

   retrieval restrictions

   for SMO object identity

USE PLAN query hint

UseEventHandler method

UseExecXmlReader method

User assemblies, maintaining

User-defined aggregates

   best practices

   creating

   implementing

User-Defined Function template

User-defined functions

User-defined types (UDTs)

   aggregate

   best practices

   binary implementation in

   for clients

     from DataReaders

     .NET Framework

     in ODBC, OLE DB, and ADO

   comparing

   creating

   Format.Native vs. Format.UserDefined implementations

   helper functions in

   IBinarySerialize

   maintaining

   null value implementation in

   objects for

   overview

   permissions for

   public members in

   purpose of

   source code for

   string implementation in

   validation in

   in Visual Studio

   in XML

User ID keyword

USER keyword in AddUser

User libraries

user_name function

UserDefinedFunctions class

UserDefinedMessage class

Users

   adding to databases

   in authentication

   schema separation from

UseWaitHandles method

using directive

   for row insertions

   for subscribers

   for transactions

UTF-16 code

V

VALID_XML validation

ValidateFullNull function

ValidateSSN function

ValidateSSNFull function

ValidateSSNFullNull function

ValidateSSNTSQL function

Validation

   for message types

   for UDTs

   for user libraries

   XML

ValidationFunctions class

ValidationMethodName property

Value comparison operators

VALUE indexes

value method

Value property

   for SMO objects

   in SqlTypes

ValueType class

VAR function

VARBINARY data type

   in clients

   vs. MAX

   maximum size for

   in messaging applications

   in SQLXML

   in XML

   VARCHAR data type

   in clients

   with MAX

   maximum size for

   in messaging applications

   with OpenXML

   for SqlTypes

   in SQLXML

   in Visual Studio

   in XML

Variables

   UDT

   XML

verbose flag in Update command

<Version> node

Versioning in SNAPSHOT isolation

   drawbacks of

   monitoring

Versions for assemblies

VIEW DEFINITION permission

Virtual memory

Visibility

   of classes

   in CLR type system

Visual Basic null values

Visual Studio

   attributes in

   automatic deployment in

   for connection information

   data types and SqlFacet in

   executing and debugging code in

   for Notification Services

void data type

W

WAIT FOR clause

WaitAll method

WaitAny method

WaitHandles method

WatchDirectory argument

Watching rowsets

Web Service Definition Language (WSDL)

   generation process

   working with

Web Services

   best practices

   HTTP endpoints

     creating

     declarations

     metadata

     in SQLXML

     SSL for

     states

     URL

   and marshaling data

   proxy classes

   SQL batches

   from SQLCLR

   SQLXML for. See SQLXML

   SSL for

   stored procedures for

   Webmethods

   WSDL for

     generation process

     working with

   XML namespaces for

WEBMETHOD clause

Webmethods

WebRequest class

WELL_FORMED_XML validation

Well-formedness rules

WHERE clause

   in DELETE

   in XQuery

WHERE EXISTS clause

WHERE NOT EXISTS clause

Whitespace entitization

Wildcards

   in OUTPUT

   in XML

Windows groups

Windows identity impersonation

Windows Management Instrumentation (WMI)

Windows XP Support Tools

WindowsIdentity property

   for in-process data access

   in SqlContext

WindowsImpersonationContext

WITH ACTIVATION clause

WITH CLEANUP clause

WITH ERROR clause

WITH EXECUTE AS clause

WITH keyword for CTEs

WITH RELATED_CONVERSATION_GROUP clause

WITH RETENTION clause

WITH SCHEMA COLLECTION clause

WITH SCHEMABINDING clause

WITH TIES clause

WITH XMLNAMESPACES clause

WithDependencies option

WithEvents keyword

WITHOUT LOGIN clause

WMI (Windows Management Instrumentation)

WMI CIM Studio tool

Wmi class

Write method

   in IBinarySerialize

   in LDim

   in MAX

   in XML

WriteLine method

WriteSchema method

WRITETEXT method

WriteXml method

   in DataSet

   in IXmlSerializable

   in LDim

Ws-Security specification

WSDL (Web Service Definition Language)

   generation process

   working with

wsdl_generator_procedure

WSDLComplex query strings

WSDLMinimal query string

WSDLSimple query strings

X

X.509 certificates

XACT_ABORT function

XACT_STATE function

XDR format schema

xdt:anyAtomicType data type

xdt:untyped data type

xdt:untypedAtomic data type

XLINQ language

XML and XML data type

   ANSI SQL standard compliance for

   best practices

   on clients

     in ADO

     in ADO.NET

     documents, fragments, and FOR XML support

     as string

   for columns

   conversions with

   functions

   indexes for

   for inserting data

   loading from files

   mapping

   as marshaling format

   namespaces in

   OpenXML enhancements

   overview

   producing

   query languages for. See XPath query language; XQuery query language

   schemas in

     collections

     for Notification Services

     in XQuery

   SELECT with. See FOR XML clause

   in service-oriented database applications

   for showplans

   in SQLXML

   streams in

   typed

   with UDTs

   for variables and parameters

XML for Analysis

xml.nodes function

XML Schema Definition language (XSD) standard

   data types in

   inline format schema

   restrictions in

xml_schema_namespace function

XML/XSLT formatter

XmlDocument class

XmlElement function

XmlForest function

XmlIgnore attribute

XmlNavigator model

xmlns attribute

XMLPARSE method

XmlReader class

XmlReaderSettings class

XMLSERIALIZE method

XmlSerializer class

XmlSerializerAssembly attribute

XmlSerializerContract class

XmlSerializers.dll file

XmlWriter class

xp_cmdshell program

xp_sendmail program

XPath data() function

XPath query language

   expressions in

   for SMO objects

   in SQLXML

XPathNavigator class

XQuery 1.0 and XPath 2.0 Data Model specification

XQuery 1.0 and XPath 2.0 Functions and Operators Version 1.0 specification

XQuery query language

   best practices

   bodies in

   functions in

   indexes in

   introduction

   multiple-document queries in

   operators in

   optimizing

   overview

   prologs in

   schemas in

   in service-oriented database applications

   vs. SQL

   inside SQL Server

   updating XML columns

   with XML data type

     exist method

     functions

     nodes method

     query method

     typed

     value method

   vs. XSLT

xs:date data type

xs:double data type

xs:maxOccurs facet

xs:minOccurs facet

xs:pattern facet

xs prefix

xs:string data type

xs:time data type

xs:timestamp data type

XSD (XML Schema Definition language) standard

   data types in

   inline format schema

   restrictions in

xsd:annotations data type

xsd:any data type

xsd:base64Binary data type

xsd:dateTime data type

xsd:decimal data type

xsd:hexBinary data type

xsd:integer data type

xsd:length facet

xsd:maxLength facet

xsd:string data type

xsi:nil attribute

xsi:prefix

xsi:schemaLocation attribute

xsi:type attribute

XSL transform for Notification Services

XSLT (Extensible Stylesheet Language Transformations)

XsltFormatter tool

Y

yield return instruction