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
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# 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
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)
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
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
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
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
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
jar files
Join equivalents in XQuery
Joins with APPLY operators
Just-In-Time (JIT) compilation
Kernel
Keyrings
Keys, encryption
KILL command
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
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
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
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
<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
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
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
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-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
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
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
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.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
yield return instruction
18.218.3.204