SQL Server 2000 Stored Procedures Handbook (Experts Voice)

Go keyword and, 48

Batch separator option, 49

stored procedures, 78

using cursors for batch operations, 78

BEGIN DISTRIBUTED TRANSACTION command

MSDTC, 87

BEGIN TRANSACTION command

simple transactions, 82

WITH MARK clause, 83

BEGIN…END code blocks

flow control of stored procedures, 21

blocking

locks, 94

buffers

SQL buffer overflow, 243

bulk update locks, 95

bulk-logged model

recovery model for database, 81