SQL Server 2000 Stored Procedures Handbook (Experts Voice)

debugging stored procedures, 58

inspecting in-built functions, 181

object ownership

DBO owning objects, 229

compared to alternative, 229

security problems, 229

parts of named object, 228

permissions issues, 228

sp_changeobjectowner system stored procedure, 228

object permissions

DENY action, 226

GRANT action, 226

permissions issues, 226

REVOKE action, 226

syntax, 226

OBJECTPROPERTY

checking if function is deterministic or not, 182

objects

tracing object creation and deletion, 168

Open method

SqlConnection class, 117

OPEN statement

accessing cursors from code, 70

operator cost

execution plan, 45

OPTIMISTIC

updatability of cursor, 69

optimistic locking

coding for integrity and concurrency, 101

logical unit of work, 101, 106

reasons for preferring, 108

row based scheme, 101, 102

checking all fields, 102

date-time column, 102

timestamp column, 102

unchecked scheme, 101

optimizing stored procedures, 35

see also high performance stored procedures.

dynamic SQL in stored procedures, 50

execution plan, 38

cost, 44

stored procedure execution plan, 42

understanding execution plan, 44

SET NOCOUNT ON option, 35

example of using, 37

WITH RECOMPILE clause, 37

reasons for using, 38

OS (Operating System) issues

concurrency, 92

Outlook

SQL Mail and, 170

OUTPUT method

returning values from stored procedures, 29

OUTPUT parameter

XP_FileExists system stored procedure, 163

overflows

SQL buffer overflow, 243