S

Sac utility, 4142

Save And Execute Package page, 234

Save As dialog box, 85

Save SSIS Package dialog box, 25

Scalability, 82, 129

Scalar functions

system-supplied, 156162

aggregate functions, 156

configuration functions, 157

cursor functions, 157

date and time functions, 158

mathematical functions, 158

metadata functions, 158

ranking functions, 162

security functions, 159

string functions, 159

system functions, 160161

system statistical functions, 161162

user -defined functions, 163164, 194196

Scalar values, 163165

Scale, 101102

Schema, 150

Schemabinding, 183

SCHEMA_NAME function, 159

Schemas, 114115

Scientific data, 102

SCOPE_IDENTITY function, 161

Script, 5356, 6970

Search arguments, 148149

Secondary database file, 111112

Secure Socket Layer (SSL), 37

Security, 83

Security function, 159

SELECT, 133, 136

SELECT clause, 143150, 160

SELECT query

create, 4950

create more complex, 5052

delete set of records, 254

as stored procedure's result set, 206

and XML AUTO, 170

SELECT statement, 182183, 199, 206

Self-referencing relationship, 9697

Separated presentation, 12

Server Management Objects (SMO), 80

Server maximum capacity, 89

Server Name drop-down list, 4547

Server node, 51

Server Registration, 4447

Service Account dialog box, 23

Service Area Configuration dialog box, 27

Service Broker, 41, 141

Services Node, 3334

SESSION_USER function, 159, 161

SET, 192

SET DATEFIRSST statement, 157

SET LANGUAGE statement, 157

Setup Progress dialog box, 2526

@severity, 267

Severity levels, 246

Simple mail transfer protocol (SMTP) e-mail, 23

Single- tier database application, 78

Smalldatetime, 106, 210

Smallint datatype, 101, 209

Smallmoney datatype, 101102, 209

SMO. See Server Management Objects (SMO)

Software failure, 8182

Sort data, 176177

Sort Order, 5051

Sort Type, 50

Source, define, 237238

sp_addmessage stored procedure, 266267

sp_depends, 182

Specify Values For Template Parameters dialog box, 5758

SQLChars, 210

SQLCmd, 6870

SqlCommand class, 132

SQLCommand object, 186

SqlConnection class, 131132

SqlDataAdapter, 133136

SqlDataReader class, 133

SQLException, 294

SQL Functions, 274

SQL Management Studio, 221223

SQL Native Client

installing SQL Server driver instead of, 123

introduction to, 138

use Multiple Active Result Sets (MARS), 139

use Query Notification, 140141

use XML datatype, 139

SQL Native Client Configuration Node, 3739

SQL Native Client network configuration, 32

SQL Native Configuration Properties dialog box, 38

SqlReader class, 133

SQLReader object, 186

SQL Reporting Services, 79

SQL Server 2000, SQL Profiler for, 61

SQL Server 2005

connecting, through object-linking and embedding database (OLE DB), 10

connecting to, through ADO.NET managed data provider, 11

connecting to, through open database connectivity (ODBC), 10

connecting to, through SQL Server Native Client, 1112

editions, 18

Express edition, 13

import data into, 228230

installation and set up, 1530

installing, 1929

SQL Profiler for, 61

See also individual editions

SQL Server Books Online, 3132, 228, 278

SQL Server Browser service, 3637

SQL ServerBufferManager, 88

SQL Server Configuration Manager

Native Client Configuration Node, 3739

Network Configuration Node, 3437

open, 32

Services Node, 3334

SQL Server 2005 Developer Edition, 15, 34

SQL Server 2005 Enterprise Edition, 18, 77

SQL Server 2005 Express Edition, 18, 34, 77

SQL Server instance, connect to default, 69

SQL Server Integration Services (SSIS), 78

SQL Server Management Studio

administer servers with, 4247

create database using, 112114

create DELETE sentence with, 253254

create UPDATE sentence with, 273274

create view in, 179180

define CHECK constraint using, 116

define Primary Key in table using, 116

manage other objects, 5253

as part of SQL Server Standard Edition, 18

registering server in, 4447

retrieve information about queries, 5455

retrieve statistics, 5556

running SELECT statement in, 143149

templates, 5758

use Database Diagrams Node, 53

use Object Explorer in, 4753

use SQL Management Studio Express, 58

use to create tables, 115

view XML data in, 166167

write scripts in, 5356

write solutions and projects in, 5657

SQL Server Management Studio

Express, 58

SQL Server Native Client, 1112

SQL Server Profiler

access event types, 62

configure general properties, 60

and create trace, 5962

run together with Performance Monitor, 6364

for SQL Server 2000, 61

view deadlocks in, 6465

when to use, 52

SQL Server replication, 78

SQL Server Report Server, 79

SQL Server Service Broker, 79

SQL Server Standard Edition, 18

SQL Server Surface Area Configuration

defined, 39

initial screen of, 40

Sac utility, 4142

use Surface Area Configuration or Features, 41

use Surface Area Configuration For Services And Connections, 40

use to enable networking protocols, 34

SQL Server Surface Area Configuration For Services And Connections dialog box, 28

SQL Server Workgroup Edition, 18

SQL XML, 122

SQUARE function, 158

SSIS. See SQL Server Integration Services (SSIS)

SSL. See Secure Socket Layer (SSL)

Standish Group International Inc., 73

Static port, 3537

Statistical calculations, 208216

Statistics, retrieving, 5556

Stored procedures, 192, 203

compared to user-defined functions, 207

design and use to retrieve scalar values, 164165

encapsulating delete operations in, 258266

encapsulating insert operations in, 241243

encapsulating update operations in, 279281

update row using, in ADO.NET, 285

See also individual stored procedures

String attributes, 103105

String functions, 159

String syntax, 104

Structured Query Language (SQL), 67

STUFF function, 1459

SUBSTRING function, 159

SUM function, 156

Surface area, 39

Surface Area Configuration For Features, 41

Surface Area Configuration For Services And Connectionsdialog box, 40

Surface Area Configuration Tool, 27, 29

Survey, write user, 7475

Sybase, 79, 123

Syntax error, 268

System Configuration Check, 2021

System Databases, 47

System.Data.Common, 130

System.Data namespace, 130

System.Data.OleDb, 131

System.Data.OracleClient, 131

System.Data.SqlClient, 131

System functions, 160161

System statistical functions, 161

System-supplied scalar functions, 156162