generic stored procedures, 131
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