Early Restore Access, features of, 58–59
ENCODING keyword, using with SQL Server Service Broker application, 134
encryption
implementing for dialogs in SQL Server Service Broker, 139
implementing in Analysis Services, 224–225
END CONVERSATION T-SQL DML statement, description of, 133
endpoints
creating for HTTP, 157
specifying for dialogs in SQL Server Service Broker application, 136
ENDxxx method, using with asynchronous queries, 98–99
Enterprise Manager, replacement of, 25
error flows, support in Integration Services, 197
ErrorCode system variable, purpose in Integration Services, 195
ErrorDescription system variable, purpose in Integration Services, 195
ETL (extraction, transformation, and loading)
relationship to DTS, 188
relationship to OLAP, 217
ETL tasks, managing with Integration Services Designer, 205–206
event handling, using with Integration Services, 201–202
event ordering, managing in SQL Server Service Broker, 128–129
event providers, defining for Notification Services application, 115–116
event type, extracting data by, 45
EventClasses element, using with ADF event schema, 114
events in Notification Services
adding, 108
overview of, 106–107
Execute method, using with XML for Analysis Services, 158
EXECUTE permission, description of, 20
execute requests, using with XMLA, 234
execution context, setting for modules, 17–18
execution plans, example of, 41
ExecutionInstanceGuid system variable, purpose in Integration Services, 195
ExecutionStatus system variable, purpose in Integration Services, 195
Exists() method, using with XML data types, 147
extended commands, using with Sqlcmd, 40
extended variables, using with Sqlcmd, 39
EXTERNAL NAME clause
using with assemblies, 75
using with extended triggers, 80
using with UDFs, 77
using with UDTs, 84
EXTERNAL_ACCESS permission, using with .NET database objects, 89