Index_R

R

RAISERROR statement

compared to return parameters, 56

error handling, 55

example of using, 56

syntax, 55

triggers, 211

RAND() function

building complex result set, 76

READ_ONLY

updatability of cursor, 68

READCOMMITTED

isolation levels, 98

READUNCOMMITTED

isolation levels, 98

recompiling stored procedures, 19

sp_recompile system stored procedure, 20

WITH RECOMPILE clause, 20

optimizing stored procedures, 37

recovery model for database

bulk-logged model, 81

full model, 81

simple model, 81

transactions, 81

recursion

nested stored procedures, 27

@@NESTLEVEL function, 27

problems with, 28

triggers, 215

direct recursion triggers, 215

indirect recursion triggers, 215

XP_SendMail system stored procedure, 170

RECURSIVE_TRIGGERS option

direct recursion triggers, 215

recycled procedures

checking data integrity, 15

referential integrity, 15

triggers, 217

REGEDIT.EXE program

Windows registry, 153

REGEDT32.EXE program

Windows registry, 153

registry

see Windows registry.

Remove All Breakpoints option

SQL Server Debugger, 60

repeatable reads, 97

REPEATABLEREAD

isolation levels, 98

REPLACE() function

compared to Parameters collection, 238

SQL injection attack solutions, 237

replication

immediate update subscriber, 214

merge replication, 214

queued update subscriber, 214

snapshot replication, 214

stored procedures, 12

procedure execution article, 13

transactional replication, 214

triggers, 213

WITH ENCRYPTION triggers, problems with, 215

Restart option

SQL Server Debugger, 60

result set

formatting result set using cursors, 73

complex result set, 76

field formatting, 73

RETURN method

returning values from stored procedures, 28

return parameters

compared to RAISERROR statement, 56

error handling, 56

RETURNS statement

creating user defined functions, 181

REVOKE action

object permissions, 226

roles

compared to user ID's, 227

permissions issues, 227

PUBLIC role, 227

sp_addrolemember system stored procedure, 227

sp_helprole system stored procedure, 227

sysmembers table, 227

sysusers table, 227

ROLLBACK TRANSACTION command

savepoints, 90

simple transactions, 82

triggers, 211

description of ROLLBACK, 212

row based scheme, optimistic locking, 101, 102

checking all fields, 102

date-time column, 102

example, 102

timestamp column, 102

row locks, 93

ROWLOCK hint, 95

Run to Cursor option

SQL Server Debugger, 60