S

savepoints, 165-168

scalability, of distributed systems, 255

scalar functions, 73, 106

system functions, 106-121

scaling-out, 244

scheduled execution, 90

schema integrity, 299-301

schema locks, 170

schema-binding, 230, 307-308

schemas, 54

scientific notation, 61

script files, running, 599-600

scripts, 152

database scripting, 152-154

securables, 541

security

access levels, 542-546

authentication, 15, 540, 543

authorization, 540

cross-database ownership chains, 549-550

database access, 544

dynamically constructed queries, 439-442

enforcement of, 49

granting database access, 554-555

granting role membership, 555

granting schema ownership, 555

logins, 552-554

network/OS access, 542

ownership chains, 549

permissions, 544-546, 556-559

principals, 540-541

roles, 546-549

securables, 541

selection of authentication mode, 551

server access, 542-543

switching of execution context, 550-551

synchronization of login and usernames, 559-562

using a proxy server, 565

using application roles, 565-566

using stored procedures, user-defined functions, and views, 562

views, 230, 256

sequence trees, 638

serialization, 391

servers, 54, 55

access, 542-543

services, managing, 3-5

Set Xact_Abort On, 201-205

shared (read) locks, 170

Shared Memory, 5

single precision, 61

source code control, 502

See also Visual SourceSafe

sp_executesql stored procedure, 437-439

sp_MSForEachDb, 466-467

sp_MSForEachTable, 466-467

special data types

cursor, 67

sql-variant, 65-67

table, 67

timestamp, 64

uniqueidentifier, 64

xml, 64-65

SQL Profiler, 490-494

SQL Server 2005 Integration Services, 604

SQL Server Agent, 4

SQL Server service, 4

SQLCMD utility, 11-12

SqlCommand, 346-348

SqlDataReader, 348-349

sql-variant data type, 65-67

SSIS. See SQL Server 2005 Integration Services

statement blocks, 80-81

statistics, 638-639

stored procedures

altering, 30-31

CLR, 216

composition of, 28-31

creating, 18-19, 28-30

defined, 12-13

deleting, 45

editing, 17, 19-22

execution of in Management Studio, 14-16

exposing as web services, 622-624

extended, 216-223

functionality, 31-40

global temporary, 224-225

listing, 41-43

listing dependent and depending objects, 45-47

for maintaining jobs, 614-617

naming conventions, 634-635

nested, 448-459

recompiling, 646-648

remote, 225-226

renaming, 44-45

role of in developing database applications, 47-49

sp_executesql, 437-439

storing, 648-650

syntax, 38-40

system, 14, 41, 214-215

temporary, 223-224

types of, 40-41

user-defined, 41, 214

viewing code of, 43-44

Str() function, 128

string functions, 124-130

Stuff() function, 130

SubString() function, 126

surrogate keys, 73

syntax, 38-40

errors, 22-23

system functions, 106-121

system stored procedures, 14, 41, 214-215

system tables, 648

system views, 648

system-defined data types, 55-67