Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

e-mail, 618

checking status, 622

Database Mail, 619-621

sending, 621-622

encryption, user-defined functions, 307

endpoints, 623-624

error handling, 183

based on @@Error, 184-186

reason for using, 183-184

Xact_Abort, 199-211

See also debugging; Try-Catch statement

errors

and batches, 146-150

Raiserror(), 180-182

syntax, 22-23

See also debugging

EventData() function, 281-283

exact numbers, 62

exclusive (write) locks, 170

Execute statements, 428-429

execution context, 639

switching of, 550-551

execution plans, 639

of distributed partitioned views, 248-253

indexed views in, 240

levels of, 640

reuse of, 639-646

reuse of query execution plans, 641

reuse of stored procedure execution plans, 644-646

standard SQL views in, 231-232

explicit transactions, 157-158, 423-424

exponents, 61

extended properties, 468

extended stored procedures, 216

creating, 217-221

registering, 222-223