S

schema

In the SQL-92 standard, a collection of database objects that are owned by a single user and form a single namespace. A namespace is a set of objects that cannot have duplicate names. For example, two tables can have the same name only if they are in separate schemas; no two tables in the same schema can have the same name. In T-SQL, much of the functionality associated with schemas is implemented by database user IDs. In database tools, schema also refers to the catalog information that describes the objects in a schema or database. In analysis services, a schema is a description of multidimensional objects, such as cubes and dimensions.

SCHEMABINDING

An option for a user-defined function or a view that prevents changes to the objects referenced by the function or view unless you first drop the view. This makes the views and functions more reliable, because they can rely on their database objects always being present.

scope

The lifetime of an object. Specifically, a variable has a scope within a single batch, which means it ceases to exist outside the batch.

script

A collection of batches, usually stored in a text file.

SELECT

The T-SQL statement used to return data to an application or another T-SQL statement, or to populate a cursor. The SELECT statement returns a tabular result set consisting of data that is typically extracted from one or more tables. The result set contains data from only those rows that match the search conditions specified in the WHERE or HAVING clauses.

Server Network utility

The Server Network utility is used to manage the server net-libraries.

Service Manager

SQL Server Service Manager is used to start, stop, and pause the SQL Server 2000 components on the server. These components run as services on Microsoft Windows NT or Microsoft Windows 2000 and as separate executable programs on Microsoft Windows 95 and Microsoft Windows 98.

SET

The statement used to alter environment settings for a session.

snapshot replication

A type of replication wherein data and database objects are distributed by copying published items via the Distributor and on to the Subscriber exactly as they appear at a specific moment in time. Snapshot replication provides the distribution of both data and structure (tables, indexes, and so on) on a scheduled basis. It may be thought of as a "whole table refresh." No updates to the source table are replicated until the next scheduled snapshot.

SNMP (Simple Network Management Protocol)

Used for troubleshooting and querying TCP/IP servers.

SQL Profiler

A tool used to trace SQL Server activity.

statement permissions

An attribute that controls whether a user can execute CREATE or BACKUP statements.

statistics

SQL Server keeps statistics about the distribution of the key values in each index and uses these statistics to determine what index(es) to use in query processing.

stored procedure

A collection of T-SQL statements with a well-defined set of inputs, called input parameters, and a well-defined set of outputs, which may be output parameters, return values, or cursors. Stored procedures allow the encapsulation of various database operations.

string concatenation

Combining of two strings, such as the results of the first name and last name columns. String concatenation can be performed using the plus (+) operator.

Structured Query Language (SQL)

A language used to insert, retrieve, modify, and delete data in a relational database. SQL also contains statements for defining and administering the objects in a database. SQL is the language supported by most relational databases, and is the subject of standards published by the International Standards Organization (ISO) and the American National Standards Institute (ANSI). SQL Server 2000 uses a version of the SQL language called T-SQL.

Subscriber

The server that receives replicated data (in the form of publications) from the Publisher.

System Monitor

The performance monitoring tool available in Windows 2000 operating systems.