Index_E

E

e-mail support, 248

encapsulating logic in stored procedures, 112

advantages, 114

example, 112

encrypted stored procedures, 239

breaking encryption, 241

ALTER PROCEDURE statement, 241

CRYPTO API, 239

storage of stored procedure, 240

syscomments table, 240

sysobjects table, 240

WITH ENCRYPTION clause, 239

Enterprise Manager

system stored procedures, 7

entity integrity, 14

triggers, 216

errata, feedback on, 248

error handling, 52

application logic, 52

example, 52

database logic, 52

@@ERROR variable, 53

example, 53

RAISERROR statement, 55

example of using, 56

return parameters, 56

returning values from stored procedures, 30

example databases

restoring to default condition, 31

exclusive locks, 94

ExecuteReader method

SqlCommand class, 117

execution plan, 38

cost, 44

importance of cost analysis, 47

operator cost, 45

query cost, 44

thick arrows as cost measure, 45

performance issues, 39

stored procedure execution plan, 42

multiple statement stored procedures, 43

understanding execution plan, 44

viewing execution plan, 39

graphical view of execution plan, 39

textual view of execution plan, 40

explicit transactions, 88

compared to implicit transactions, 88

extended stored procedures, 6

compared to stored procedures, 136

sp_ prefix, 136

system stored procedures, 136

undocumented features, 152

file system stored procedures, 161

finding undocumented functionality, 152

Windows registry system stored procedures, 152

xp_ prefix, 136

extent locks, 93