SQL Server 2000 Stored Procedures Handbook (Experts Voice)

A Guide to the Index

The index is arranged hierarchically, in alphabetical order, with symbols preceding the letter A. Most second-level entries and many third-level entries also occur as first-level entries. This is to ensure that users will find the information they require however they choose to search for it.

Symbols

@@ERROR variable

database logic error handling, 53

examples of using, 54

@@FETCH_STATUS variable

accessing cursors from code, 72

@@NESTLEVEL function

nested stored procedures, 27, 131

@@ROWCOUNT variable

triggers, 211

@@TRANCOUNT variable

nesting transactions, 84

0x80000000 status bit

creating system stored procedures, 140

care in using, 140

documentation, 141

example, 141

naming guidelines, 140

disabling and re-enabling users, 139

effects of setting, 138

get_sid function, 143

security issues, 139

system stored procedures, 137

toggling on and off, 168

1433 port

security problems, 221

Категории