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