E

editions of SQL Server, 12–16

ENABLE TRIGGER statement, 329

encryption. See also security

certificate for, 315–316

decrypting data, 317–318

definition of, 314

encrypting data, 316–317

keys for, 315–316

SQL Native Client used by, 5

for transport security, 246–247

endpoints

in database mirroring, 551–555

in Service Broker

creating, 243–244

definition of, 214, 227

English Query, 64

enterprise data management, enhancements for, 51–52

Enterprise Edition

definition of, 12–13

features for, 14–15

memory used by, 13

operating systems supported by, 13

processors used by, 13

Error Reporting, enabling, 78

errors. See also logs; troubleshooting

alerts based on, 114–115

number 1101, 7

number 1105, 7

number 3621, 141–142

number 3959, 7

number 3967, 7

$(ESCAPE_DQUOTE) escape macro, 135

$(ESCAPE_NONE) escape macro, 135

$(ESCAPE_RBRACKET) escape macro, 135

$(ESCAPE_SQUOTE) escape macro, 135

estimated execution plan, 455–459

Evaluation Edition, 12–13

event alerts, 114–115

event forwarding, 136

event notifications

creating, 431–433

definition of, 417, 431

list of events for which to be notified, 433

for SQL Server Agent jobs, 108–109

for SQL Server Agent operators, 111–112

Event Viewer, Windows, 155

EVENTDATA() function, 325–326

events

in database mirroring, 585–589

definition of, 418

duration of, units of time used for, 425

monitoring

notifications for, 417, 431–433

reasons for, 417–418

SQL Trace for, 418–431

in WMI, 137

executable, assembly packaged as, 280

EXECUTE AS statement, 312–314

EXECUTE permission, for Service Broker objects, 257

extended stored procedures, CLR compared to, 276