E


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




Microsoft SQL Server 2005 New Features
Microsoft SQL Server 2005 New Features
ISBN: 0072227761
EAN: 2147483647
Year: 2005
Pages: 80
Authors: Michael Otey

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net