SQL Server 2000 Stored Procedures Handbook (Experts Voice)

problems with, 131

get_sid function

0x80000000 status bit, 143

sp_getsid stored procedure, 143

GETDATE() function, 180

non-deterministic functions, 184

GLOBAL scope

scope for cursor, 67

system stored procedures, 136

user defined functions, 195

global tables, 144

creating using sp_ prefix, 144

global views, 144

creating using sp_ prefix, 144

Go keyword, 48

as command terminator, 48

batch operations and, 48

Batch separator option, 49

not T-SQL command, 48

Go option

SQL Server Debugger, 60

GOTO label

decisions, 25

flow control of stored procedures, 25

GRANT action

object permissions, 226

graphical view of execution plan, 39

Display Estimated Execution Plan option, 39

Query Analyzer, 39

Show Execution Plan option, 39

group accounts

permissions issues, 223

grouping stored procedures, 129

example, 129

not good practice, 130

guest user

advantages of deleting, 225, 231