A

ABP, Windows Authentication (see )

ACID (Atomicity, Consistency, Isolation, and Durability), Transactions

adjacent broker protocol (ABP), Routing and Distribution, Service Broker Endpoints, Configuring Adjacent Broker Protocol Connections, Windows Authentication

certificate authentication, Windows Authentication

connections for endpoints, Service Broker Endpoints

overview, Routing and Distribution

Windows authentication, Configuring Adjacent Broker Protocol Connections

AFTER triggers, Triggers, Triggers, Triggers, The inserted and deleted Special Tables, Identifying the Number of Affected Rows, Not Firing Triggers for Specific Statements, Not Firing Triggers for Specific Statements, Not Firing Triggers for Specific Statements, Nesting and Recursion, Nesting and Recursion, Auditing Example, INSTEAD OF Triggers

auditing example, Auditing Example

COLUMNS_UPDATED function, Nesting and Recursion

compared to INSTEAD OF, INSTEAD OF Triggers

deleted tables, Triggers

identifying number of rows, The inserted and deleted Special Tables

identifying type, Identifying the Number of Affected Rows

inserted tables, Triggers

nesting, Not Firing Triggers for Specific Statements

not firing for specific statements, Not Firing Triggers for Specific Statements

overview, Triggers

recursion, Not Firing Triggers for Specific Statements

UPDATE predicate, Nesting and Recursion

arguable constructs, Cursors

arithmetic operations, Deploying the UDT Using T-SQL

asymmetric key authentication in dialog conversations, Dialog Security

asynchronous delivery in dialog conversations, In Order

asynchronous processing in Service Broker, Reliable SOA

Atomicity, Consistency, Isolation, and Durability (ACID), Transactions

audience for this book, Introduction

auditing example in AFTER triggers, Auditing Example

automatic handling of sequences, Used with Views