S

Index

[A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y]

SAFE permissions
SalesServer
Scalability
Scalar functions
Sch-S lock
Scheduled notifications, merging
Scheduling and Delivery Processor
Scheduling backups
Schema(s)
     ANSI concept for
     assign schema as default
     create
     default
     defining, for application foundation
     introducing
     managing access to
     user-schema separation
Schemas
Scripts 2nd
Search By text box 2nd
Secondary XML index
Secure by Default principle
Secure Sockets Layer (SSL) 2nd
Select A Page pane
SELECT clause
SELECT permissions
SELECT statement 2nd
SELF statement
Self-signed certificate
Semantic Model Definition Language (SMDL)
SERIALIZABLE isolation level 2nd
Server role
Server role membership information
ServerName
Service interface
SET STATISTICS IO option
Shared (S) lock
Shared Data Source dialog box
Shared data source, creating
Shared Schedules
Shredding
SightNotifications.htm
Simple backup information
Simple backup strategy
Simple mode
Simple Object Access Protocol (SOAP)
Simple recovery model
Smalldatetime
SMDL [See Semantic Model Definition Language (SMDL)]
SMS text message 2nd 3rd
SMTP server
Snapshot Agent page
SNAPSHOT isolation 2nd
Snapshot Replication
SOAP [See Simple Object Access Protocol (SOAP)]
SOAPSuds
Solution Explorer 2nd 3rd 4th 5th 6th 7th 8th 9th
Solution Explorer Window
Sort operator
Sort order, add to dynamic query
Sorted totals summary, creating
Sorting results
Sounds (.wav files)
Source code control
sp_addlinkedserver stored procedure
sp_dropserver stored procedure
sp_ExecuteSql
SQL Maintenance Plan Wizard, scheduling backups using
SQL Management Studio
SQL Server 2000 2nd 3rd
SQL Server 2000 XML functionality
SQL Server 2003
SQL Server 2005 2nd 3rd
     access, through Extra layer
     approaches for managing connections to remote data sources
     configuring, to listen on specific IP address
     connect to, with user name and password
     connect, using SQL Server Authentication
     connecting to, through HTTP Endpoints
     convert database to, from SQL Server 2000
     Data Extension
     direct access to
     inserting, updating, or deleting data from remote sources in
     lock types used by
     reading data from remote sources in
     transactions in
     using, to read data from multiple data sources
     validating TCP/IP is enabled in
     XML support
SQL Server 2005 Developer
SQL Server 2005 Enterprise
SQL Server 2005 Evaluation Edition
SQL Server Agent 2nd 3rd
SQL Server Agent Jobs
SQL Server Agent Service
SQL Server API 2nd
SQL Server API stored procedure
SQL Server authentication 2nd
SQL Server Business Intelligence Development Studio (BIDS) 2nd
SQL Server Configuration Manager 2nd
SQL Server database 2nd 3rd
SQL Server database, managing access to
     granting access to databases
     granting database permissions
     managing application roles
SQL Server instance
     connecting to
     connecting to SQL Server instance
     default Windows logins
     selecting authentication mode
SQL Server Integration Services (SSIS) 2nd 3rd 4th
SQL Server logins, granting access to
SQL Server Management Studio 2nd 3rd 4th
     create backup with
     creating project and, solution
     remove configured linked server in
     restore database using
SQL Server Management Studio Query Builder
SQL Server Optimizer
SQL Server Profiler
SQL Server Profiler trace
SQL Server Reporting Services
SQL Server Surface Area Configuration tool 2nd 3rd
SQL Server transactions
SQL Sever instance, access remotely
SQL statement
SQL-injection attack
SQL/CLR debugging
SQLNCLI 2nd
SQLOLEDB
SQLTransaction class
SSIS [See SQL Server Integration Services (SSIS)]
SSL [See Secure Sockets Layer (SSL)]
Statistical values
     computing
     MIN and MAX
     using AVG
     using complex statistical functions
     using DISTINCT keyword
STDEV
STDEVP
Stop Instance Confirmation dialog box
Stored procedure permissions
Stored procedures [See also individual stored procedures]
     creating, to encapsulate operations to be exposed publicly
     executing
     managing security for
Stub
     add code to
     create aggregate function
SubQuery, computing running total using
Subscriber data
Subscriber Device data
Subscribers
     adding
     specifying, for notification
Subscribing application
Subscription class
Subscription schema
Subscriptions, adding
Subtotals, ROLLUP to compute
SUM function 2nd
System configuration information
System database, restoring
System.Data.SqlClient namespace