Index_P


P

page locks, 93

PAGLOCK hint, 95

parameters

return parameters in error handling, 56

stored procedures, 18, 20, 131

avoiding too many parameters, 132

matching input and ouput parameters, 31

Parameters collection

compared to REPLACE() function, 238

sp_executesql system stored procedure, 237, 238

SQL injection attack solutions, 237

password column

sysxlogins table, 224

passwords

attacking with PWDCOMPARE() function, 224

comparing with PWDCOMPARE() function, 224

generating random password, 223

sa password, 223

pausing execution

flow control of stored procedures, 26

SQL Server Agent, 26

WAITFOR() function, 26

performance tuning

administration and stored procedures, 120

permissions issues

database objects, 225

group accounts, 223

guidelines for setting permissions, 231

login ID's, 224

object ownership, 228

object permissions, 226

roles, 227

SQL injection attacks, 239

SQL Server Debugger, 58

SQL Server security vulnerabilities, 223

statement permissions, 226

user accounts, 223

user ID's, 225

pessimistic locking

coding for integrity and concurrency, 100

phantom rows, 97

port 1433

security problems, 221

POWER() function

COLUMNS_UPDATED test, 206

procedure execution article

serializable procedure execution article, 13

stored procedures and replication, 13

PUBLIC role, 227

advantages of removing, 228

SQL injection attacks, 239

pubs example database

restoring to default condition, 31

PWDCOMPARE() function

attacking passwords, 224

comparing passwords, 224

PWDENCRYPT() function

SQL buffer overflow, 243




SQL Server 2000 Stored Procedures Handbook
SQL Server 2000 Stored Procedures Handbook (Experts Voice)
ISBN: 1590592875
EAN: 2147483647
Year: 2005
Pages: 100

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net