Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

A

access control lists (ACLs), Setting Agent Security and Process Accounts
ACLs (access control lists), Setting Agent Security and Process Accounts
Active Directory, Microsoft SQL Server 2005 Editions, Services for SQL Server, Installing a SQL Server Instance, Working with System Stored Procedures, Flushing Cache with Checkpoints
adding and removing information, Flushing Cache with Checkpoints
Group Policy, Installing a SQL Server Instance
Helper, Microsoft SQL Server 2005 Editions
Stored Procedures, Working with System Stored Procedures
ActiveX Scripts, Setting Steps to Execute
Activity Monitor, Monitoring Tools and Resources
Address Windowing Extensions (AWE), Setting Authentication Mode, Using Fixed Memory
administrator user account, Special Purpose Logins and Users
administrators group, Special Purpose Logins and Users
Advanced Intelligent Tape (AIT), Selecting Backup Devices and Media
affinity settings, Allocating Memory for Queries
AIT (Advanced Intelligent Tape), Selecting Backup Devices and Media
alerts, Creating Trace Logs, Managing Alerts, Managing Alerts, Managing Alerts, Creating Error Message Alerts, Handling Alert Responses, Handling Job Alerts, Copying Alerts, Operators, and Scheduled Jobs from One Server to Another
copying, Copying Alerts, Operators, and Scheduled Jobs from One Server to Another
default, Managing Alerts
deleting, enabling, and disabling, Handling Alert Responses
error message, Managing Alerts
handling responses, Creating Error Message Alerts
job, Handling Job Alerts
managing, Managing Alerts
ALTER DATABASE command, Setting Database Options in SQL Server Management Studio, Expanding Databases and Logs Manually, Copying and Moving Databases
Alter Setting server-level permission, Executing Queries and Changing Settings
Analysis Server, Service Accounts for SQL Server, Using the Graphical Administration Tools, Installing a SQL Server Instance
Analysis Services, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Deploying Microsoft SQL Server 2005, Using SQL Server Integration Services, Creating New Instances of SQL Server, Installing a SQL Server Instance, Installing a SQL Server Instance, Managing the Services Configuration, Managing SQL Server Component Feature Access, Working with the NETWORK SERVICE and SYSTEM Logins, Stage 1: Source and Destination Configuration, File-Based Data Connections
components/features of, Managing SQL Server Component Feature Access
selected service accounts for, Working with the NETWORK SERVICE and SYSTEM Logins
anonymous connections, Managing SQL Server Component Feature Access
anonymous subscription, Subscription Essentials
ANSI compliance, Controlling ANSI Compliance at the Database Level
ANSI SET, Techniques for Managing SQL Server Configuration Options
APIs, Working with System Stored Procedures (see )
application database roles, Creating Standard Database Roles
application log, Working with the Event Logs
application programming interfaces (APIs), Working with System Stored Procedures, Working with Integration Services, Using Distributed Transactions
managing distributed transactions, Using Distributed Transactions
run-time, Working with Integration Services
application roles, Database Roles
articles, An Overview of Replication
Assembly Registration tool, Installing a SQL Server Instance
asynchronous cursor population, Ensuring Connectivity and Data Access
auditing, Determining System and Server Information, Determining System and Server Information, Setting Authentication Mode
configuring, Determining System and Server Information
setting level, Setting Authentication Mode
authentication, Services for SQL Server, Installing a SQL Server Instance, Installing a SQL Server Instance, Determining System and Server Information, Determining System and Server Information, Determining System and Server Information, Examining Effective Permissions, Examining Effective Permissions
(see also )
combined, Determining System and Server Information
configuring, Determining System and Server Information
domain, Determining System and Server Information
Mixed Mode, Installing a SQL Server Instance, Examining Effective Permissions
modes, Examining Effective Permissions
Auto Shrink option, Modifying Databases Using ALTER DATABASE, Viewing, Changing, and Overriding Database Options
autocommit mode, Ensuring Connectivity and Data Access
Autogrowth feature, Creating Databases in SQL Server Management Studio, Creating Secondary Data and Log Files
autoloader tape systems, Selecting Backup Devices and Media
AWE (Address Windowing Extensions), Setting Authentication Mode, Using Fixed Memory

B

backup devices and media, Planning for Backups of Very Large Databases, Creating a Backup Device, Restoring a Database from a Normal Backup, Restoring a Database from a Normal Backup
creating, Creating a Backup Device
restoring from, Restoring a Database from a Normal Backup
backups, Setting the Index Fill, Setting the Index Fill, Database Files and Logs, Backing Up and Recovering SQL Server 2005, Initial Backup and Recovery Planning, Planning for Mirroring and Mirrored Database Backups, Planning for Backups of Replicated Databases, Selecting Backup Devices and Media, Creating a Backup Device, Adding to an Existing Backup Set, Log Truncation Options, Restoring Files and Filegroups
configuring options, Setting the Index Fill
devices, Database Files and Logs
full-text catalogs, Log Truncation Options
of replicated databases, Planning for Mirroring and Mirrored Database Backups
of very large databases, Planning for Backups of Replicated Databases
performing, Creating a Backup Device
planning, Backing Up and Recovering SQL Server 2005
restoring database to different location, Restoring Files and Filegroups
strategies, Selecting Backup Devices and Media
striped, Adding to an Existing Backup Set
types of, Initial Backup and Recovery Planning
batch-level options, Techniques for Managing SQL Server Configuration Options
BCP (bulk copy program), SQLCMD, SQLCMD, Importing, Exporting, and Transforming Data, Stage 4: Save and Execute, BCP Basics, BCP Basics, BCP Syntax, BCP Permissions and Modes, BCP Permissions and Modes, Importing Data with BCP, Importing Data with BCP, Replication Agents and Jobs
exporting data, Importing Data with BCP
importing data, BCP Permissions and Modes
key parameters, BCP Basics
permissions and modes, BCP Permissions and Modes
scripts, Importing Data with BCP
switches, BCP Syntax
syntax, SQLCMD, BCP Basics
binary data type, Using Native Data Types
Binn directory, Setting Database Engine Startup Parameters, Managing Services from the Command Line
blocking connections, Troubleshooting Deadlocks and Blocking Connections, Tracking Command Execution in SQL Server
broker queues, Examining Permissions Granted to Securables
BTree structure, Managing Views
bulk copy program, SQLCMD (see )
BULK INSERT command, BCP Scripts
bulk-logged recovery model, Managing Cross-Database Chaining and External Access Options, Initial Backup and Recovery Planning
Business Intelligence Development Studio, Using the Graphical Administration Tools, Deploying Microsoft SQL Server 2005, Importing, Exporting, and Transforming Data, Working with Integration Services

C

cache flushing with checkpoints, Configuring Backup and Restore Time-Out Options
cache-hit ratio, Setting Authentication Mode, Understanding Data Pages
Catalog Stored Procedures, Working with System Stored Procedures
Catalog views, Configuring and Tuning Microsoft SQL Server, Accessing SQL Server Configuration Data, Working with System Stored Procedures
catalogs, Working with Full-Text Search, Working with Full-Text Search, Viewing Catalog Properties, Creating Catalogs, Editing Indexing of Tables and Views, Using Scheduled Jobs to Populate Catalogs for a Specific Table or View, Rebuilding Current Catalogs, Rebuilding Current Catalogs
cleaning up old, Rebuilding Current Catalogs
creating, Viewing Catalog Properties
methods for populating, Working with Full-Text Search
populating full-text, Editing Indexing of Tables and Views
rebuilding current, Using Scheduled Jobs to Populate Catalogs for a Specific Table or View
removing, Rebuilding Current Catalogs
viewing properties, Working with Full-Text Search
chaining, Setting Online, Offline, or Emergency Mode
character data type, Using Native Data Types
checkpoints, Configuring Backup and Restore Time-Out Options, Configuring Backup and Restore Time-Out Options, Configuring Recovery, Logging, and Disk I/O Error-Checking Options
flushing cache with, Configuring Backup and Restore Time-Out Options
occur at various times, Configuring Recovery, Logging, and Disk I/O Error-Checking Options
checksums, Configuring Recovery, Logging, and Disk I/O Error-Checking Options
client-side caching, Using SQL Server Integration Services
CLR (Common Language Runtime) Integration, Managing SQL Server Component Feature Access
CLR assemblies, Working with the System Catalog and Catalog Views
CLR Assembly Catalog views, Accessing SQL Server Configuration Data
CLR objects, Managing SQL Server Component Feature Access
clustered indexes, Configuring Year 2000 Support, Understanding Indexes, Understanding Indexes, Using XML Indexes, Stage 3: Formatting and Transformation
determines where rows will be inserted, Stage 3: Formatting and Transformation
vs. nonclustered, Using XML Indexes
cold standby servers, Initial Backup and Recovery Planning, Restoring a Database to a Different Location, Creating a Cold Standby, Using DBCC CHECKCATALOG
collation, Changing Collation and Rebuilding the Master Database, Changing Collation and Rebuilding the Master Database, Creating Databases in SQL Server Management Studio, Adding Linked Servers
changing, Changing Collation and Rebuilding the Master Database
compatible controls, Adding Linked Servers
Windows names, Creating Databases in SQL Server Management Studio
Collation Designator, Installing a SQL Server Instance
collections, Overview of SQL Server 2005 Security
columns, Using the Database Engine Tuning Advisor
COM objects (component object model) objects, Managing SQL Server Component Feature Access
command line, Managing Services from the Command Line
command-line tools, Using the Graphical Administration Tools
(see also individual command-line tool names)
Common Language Runtime Integration (CLR) Integration, Managing SQL Server Component Feature Access
Compatibility views, Configuring and Tuning Microsoft SQL Server, Working with the System Catalog and Catalog Views
component object model (COM) objects, Managing SQL Server Component Feature Access
Computer Management, Enabling or Preventing Automatic SQL Server Startup, Setting Database Engine Startup Parameters, Starting, Stopping, and Configuring the Microsoft Distributed Transaction Coordinator
configuration parameters, Executing Queries and Changing Settings, Executing Queries and Changing Settings, Executing Queries and Changing Settings, Executing Queries and Changing Settings
advanced, Executing Queries and Changing Settings
checking and setting, Executing Queries and Changing Settings
standard, Executing Queries and Changing Settings
connection-level options, Techniques for Managing SQL Server Configuration Options
connections, Setting Authentication Mode, Setting Authentication Mode, Setting Parallel Processing, Configuring Threading, Priority, and Fibers, Configuring Threading, Priority, and Fibers, Setting Maximum User Connections, Configuring Remote Server Connections, .NET Framework Data Provider Connections, BCP Permissions and Modes
configuring user and remote, Configuring Threading, Priority, and Fibers
default, Setting Maximum User Connections
file-based, .NET Framework Data Provider Connections
matching threads to, Setting Parallel Processing
RPC, Configuring Remote Server Connections
trusted, Setting Authentication Mode, BCP Permissions and Modes
untrusted, Setting Authentication Mode
constraints, Using the Database Engine Tuning Advisor, Using the Database Engine Tuning Advisor, Using the Database Engine Tuning Advisor, Using the Database Engine Tuning Advisor, Using the Database Engine Tuning Advisor, Using the Database Engine Tuning Advisor, Using the Database Engine Tuning Advisor, Using the Database Engine Tuning Advisor, Setting Unique Constraints, Using Foreign Key Constraints, Using Foreign Key Constraints, Using Check Constraints
check, Using the Database Engine Tuning Advisor, Using Foreign Key Constraints
column, Using the Database Engine Tuning Advisor
foreign key, Using the Database Engine Tuning Advisor, Using Foreign Key Constraints
not null, Using the Database Engine Tuning Advisor, Using Check Constraints
primary key, Using the Database Engine Tuning Advisor, Setting Unique Constraints
table, Using the Database Engine Tuning Advisor
unique, Using the Database Engine Tuning Advisor
control flow statements, Setting Configuration Options
Copy Database Wizard, Attaching a Database with Only Data Files
counter logs, Creating and Managing Performance Logging
CPU, SQL Server 2005 and Your Hardware, SQL Server 2005 and Your Hardware, Allocating Memory for Queries
64-bit processors vs. 32-bit, SQL Server 2005 and Your Hardware
optimizing usage, Allocating Memory for Queries
cross-database chaining, Setting Online, Offline, or Emergency Mode, Attaching and Detaching Databases
Current Activity resources viewer, Troubleshooting Deadlocks and Blocking Connections
cursor options, Controlling ANSI Compliance at the Database Level
Cursor Stored Procedures, Working with System Stored Procedures
Customer Feedback Reporting, Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting

D

DAT (digital audio tape) drives, Selecting Backup Devices and Media
data definition language (DDL), Using SQL Server Integration Services, Working with Full-Text Search, Database Roles, Managing Database Permissions, Using Distributed Transactions
Data Integration Services, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Editions
data manipulation language (DML) commands, Using Distributed Transactions
Data Mining Extensions, Managing SQL Server Component Feature Access
data mining, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Using SQL Server Integration Services, Managing SQL Server Component Feature Access
data pages, Getting Started with Tables
data protection, SQL Server 2005 and Your Hardware
Data Spaces and Full-Text Catalog views, Accessing SQL Server Configuration Data
Data Transformation Services (DTS), Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Deploying Microsoft SQL Server 2005, Managing the Services Configuration, Working with Integration Services
data truncation, Stage 3: Formatting and Transformation
data types, Using Native Data Types
data warehousing, Importing, Exporting, and Transforming Data
database consistency check, Viewing, Editing, Running, and Deleting Maintenance Plans (see )
Database Engine Stored Procedures, Working with System Stored Procedures
Database Engine Tuning Advisor, Using the Graphical Administration Tools, Managing Views, Understanding Indexes, Using XML Indexes, Managing Indexes
Database Engine, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Editions, Ensuring Connectivity and Data Access, Creating New Instances of SQL Server, Creating New Instances of SQL Server, Managing the Services Configuration, Managing SQL Server Component Feature Access, Managing SQL Server Component Feature Access, Configuring the Native Client Protocol Order, Accessing SQL Server Configuration Data, Working with Database Options, Managing the Enterprise, Setting Database Engine Startup Parameters, Managing the SQL Server Command-Line Executable File, Managing the SQL Server Command-Line Executable File, Allowing and Disallowing System Updates, Recovering from a Bad Configuration
components, Managing SQL Server Component Feature Access
connecting using TCP/IP, Configuring the Native Client Protocol Order
default instance, Creating New Instances of SQL Server, Managing the SQL Server Command-Line Executable File
features of, Managing SQL Server Component Feature Access
modes of operation, Managing the Enterprise
multiple instances of, Microsoft SQL Server 2005 Administration Overview, Allowing and Disallowing System Updates, Recovering from a Bad Configuration
named instance, Creating New Instances of SQL Server, Managing the SQL Server Command-Line Executable File
setting startup parameters, Setting Database Engine Startup Parameters
Database Mail, Managing SQL Server Component Feature Access, Working with System Stored Procedures, Database Automation and Maintenance, Overview of Database Automation and Maintenance, Using Database Mail, Performing the Initial Database Mail Configuration, Managing Database Mail Profiles and Accounts
initial configuration, Using Database Mail
profiles and accounts, Performing the Initial Database Mail Configuration
stored procedures, Working with System Stored Procedures
system parameters, Managing Database Mail Profiles and Accounts
Database Mail Configuration Wizard, Performing the Initial Database Mail Configuration, Performing the Initial Database Mail Configuration
database maintenance, Configuring Target Servers, Configuring Target Servers, Database Maintenance Checklist, Creating Maintenance Plans
checklist, Configuring Target Servers
plans, Database Maintenance Checklist
reports and history, Creating Maintenance Plans
Database Maintenance Plan Stored Procedures, Working with System Stored Procedures
database mirroring, Microsoft SQL Server 2005 Editions, Ensuring Availability and Scalability, Managing SQL Server Component Feature Access, Initial Backup and Recovery Planning, Initial Backup and Recovery Planning, Initial Backup and Recovery Planning, Planning for Mirroring and Mirrored Database Backups, Restoring the Master Database, Configuring Mirroring, Configuring Mirroring, Overview of Database Automation and Maintenance, Failing Over to a Secondary Database
configuring, Restoring the Master Database
managing, Configuring Mirroring
monitoring status and performance, Configuring Mirroring
planning for, Initial Backup and Recovery Planning
to create standby servers, Initial Backup and Recovery Planning
Database Mirroring Catalog views, Accessing SQL Server Configuration Data
database objects, Checking System and Sample Databases, Managing SQL Server 2005 Security, Manipulating Schemas, Tables, Indexes, and Views
database options, Working with Database Options, Checking and Setting Configuration Parameters, Altering Databases and Their Options
altering, Altering Databases and Their Options
reference summary, Checking and Setting Configuration Parameters
database owner (dbo) user, Working with the NETWORK SERVICE and SYSTEM Logins, Statement Permissions
database Recovery Model, Creating Secondary Data and Log Files, Preparing for Transactional Replication
database roles, Server Roles, Server Roles, Creating Standard Database Roles, Creating Standard Database Roles
creating application, Creating Standard Database Roles
creating standard, Creating Standard Database Roles
three types of, Server Roles
Databaseproperty function, Configuring Recovery, Logging, and Disk I/O Error-Checking Options
Databases and Files Catalog views, Accessing SQL Server Configuration Data
databases, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Administration Overview, Working with Database Options, Configuring Year 2000 Support, Core Database Administration, Core Database Administration, Database Files and Logs, Database Files and Logs, Database Administration Basics, Viewing Database Information in SQL Server Management Studio, Viewing Database Information Using T-SQL, Viewing Database Information Using T-SQL, Creating Databases, Creating Databases in SQL Server Management Studio, Altering Databases and Their Options, Setting Database Options in SQL Server Management Studio, Modifying Databases Using ALTER DATABASE, Modifying Databases Using ALTER DATABASE, Controlling ANSI Compliance at the Database Level, Configuring Cursor Options, Setting Online, Offline, or Emergency Mode, Setting Online, Offline, or Emergency Mode, Setting Online, Offline, or Emergency Mode, Configuring Recovery, Logging, and Disk I/O Error-Checking Options, Viewing, Changing, and Overriding Database Options, Viewing, Changing, and Overriding Database Options, Viewing, Changing, and Overriding Database Options, Viewing, Changing, and Overriding Database Options, Expanding Databases and Logs Manually, Compressing and Shrinking a Database Manually, Renaming a Database, Dropping and Deleting a Database, Attaching and Detaching Databases, Attaching and Detaching Databases, Attaching a Database with Only Data Files, Attaching a Database with Only Data Files, Creating Secondary Data and Log Files, Creating Secondary Data and Log Files, Preventing Transaction Log Errors, Revoking Access Rights and Roles by Server Login, Manipulating Schemas, Tables, Indexes, and Views, Backing Up Full-Text Search Catalogs, Database Automation and Maintenance, Configuring Target Servers, Viewing, Editing, Running, and Deleting Maintenance Plans
(see also individual database names)
administrators, Microsoft SQL Server 2005 Administration Overview
administration basics, Database Files and Logs
altering, Altering Databases and Their Options
ANSI compliance, Controlling ANSI Compliance at the Database Level
architecture, Microsoft SQL Server 2005 Administration Overview
attaching and detaching, Dropping and Deleting a Database
Autogrowth feature, Creating Databases in SQL Server Management Studio, Creating Secondary Data and Log Files
automatic options, Modifying Databases Using ALTER DATABASE
automation and maintenance, Database Automation and Maintenance
Auto Shrink option, Modifying Databases Using ALTER DATABASE, Viewing, Changing, and Overriding Database Options
compressing and shrinking manually, Expanding Databases and Logs Manually
controlling user access, database state, and administration, Configuring Cursor Options, Revoking Access Rights and Roles by Server Login
copying and moving, Attaching a Database with Only Data Files
creating, Creating Databases
cross-database chaining, Setting Online, Offline, or Emergency Mode, Attaching and Detaching Databases
dropping and deleting, Renaming a Database
expanding manually, Viewing, Changing, and Overriding Database Options
external access options, Setting Online, Offline, or Emergency Mode, Attaching and Detaching Databases
files and logs, Core Database Administration, Viewing, Changing, and Overriding Database Options
in SQL Server 2005, Core Database Administration
integrity, Viewing, Editing, Running, and Deleting Maintenance Plans
maintenance, Configuring Target Servers
managing, Working with Database Options, Configuring Year 2000 Support, Viewing, Changing, and Overriding Database Options, Attaching a Database with Only Data Files
modifying using ALTER DATABASE, Setting Database Options in SQL Server Management Studio
renaming, Compressing and Shrinking a Database Manually
restoring, Creating Secondary Data and Log Files, Backing Up Full-Text Search Catalogs
sample, Viewing Database Information Using T-SQL
setting online, offline, or emergency mode, Setting Online, Offline, or Emergency Mode
system, Database Files and Logs, Viewing Database Information Using T-SQL
template, Preventing Transaction Log Errors
viewing, changing, and overriding options, Configuring Recovery, Logging, and Disk I/O Error-Checking Options
viewing information using SQL Server Management Studio, Database Administration Basics
viewing information using T-SQL, Viewing Database Information in SQL Server Management Studio
DBCC command (database consistency check), Viewing, Editing, Running, and Deleting Maintenance Plans
DB-Library, Setting the Index Fill
dbo (database owner) user, Working with the NETWORK SERVICE and SYSTEM Logins, Statement Permissions
dbo schema, Manipulating Schemas, Tables, Indexes, and Views
DDL (data definition language), Using SQL Server Integration Services, Working with Full-Text Search, Database Roles, Managing Database Permissions, Using Distributed Transactions
deadlocks, Troubleshooting Deadlocks and Blocking Connections
declarative ordering, Replication Variants, Preparing for Merge Replication
dedicated administrator connection, Ensuring Connectivity and Data Access
default mapping, Building a Query
destination servers, Creating a Warm Standby
Developer Edition, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Using Fixed Memory
digital audio tape (DAT) drives, Selecting Backup Devices and Media
Digital Linear Tape (DLT) format, Selecting Backup Devices and Media
disk drives, SQL Server 2005 and Your Hardware, Selecting Backup Devices and Media
disk duplexing, Configuring the I/O Subsystem
disk I/O errors, Configuring Recovery, Logging, and Disk I/O Error-Checking Options
disk mirroring, SQL Server 2005 and Your Hardware
disk striping without parity, SQL Server 2005 and Your Hardware
Distributed Queries Stored Procedures, Working with System Stored Procedures
distributed queries, Working with System Stored Procedures, Linked Servers and Distributed Transactions, Creating New Traces
distributed query access, Object Permissions by Login
Distributed Transaction Coordinator, Microsoft SQL Server 2005 Editions, Starting, Stopping, and Configuring SQL Server Agent, Using Distributed Transactions, Using Distributed Transactions, Replication Variants
distributed transactions, Linked Servers and Distributed Transactions, Replication Variants
Distribution Agent, Replication Components, Subscription Essentials, Creating Subscriptions
distribution databases, Creating Distribution Databases, Deleting Distribution Databases, Planning for Mirroring and Mirrored Database Backups, Planning for Backups of Replicated Databases
creating, Creating Distribution Databases
deleting, Deleting Distribution Databases
distributors, Preparing for Merge Replication, Preparing for Merge Replication, Preparing for Merge Replication, Setting Up a New Distributor
administration, Preparing for Merge Replication
new, Preparing for Merge Replication
updating, Setting Up a New Distributor
DLT (Digital Linear Tape) format, Selecting Backup Devices and Media
DML (data manipulation language) commands, Using Distributed Transactions
domain accounts, Services for SQL Server, Setting the Startup Service Account, Determining System and Server Information, Windows Authentication, Accessing Alerts, Operators, and Jobs
DTS 2000 Package Migration Wizard, Using SQL Server Integration Services
DTS Import/Export Wizard, Integration Services Tools
DTS (Data Transformation Services), Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Deploying Microsoft SQL Server 2005, Managing the Services Configuration, Working with Integration Services
dump directories, Managing the Services Configuration, Setting the Startup Service Account, Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting
Dynamic management view, Working with the System Catalog and Catalog Views, Working with System Stored Procedures
dynamic memory, Setting Authentication Mode, Tuning Memory Usage
dynamic setting, Executing Queries and Changing Settings

E

e-mail, Working with System Stored Procedures
encryption options, Stage 4: Save and Execute
Endpoints Catalog views, Accessing SQL Server Configuration Data
Enterprise Edition, SQL Server 2005 and Your Hardware, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Creating New Instances of SQL Server, Using Fixed Memory, Allocating Memory for Queries, Configuring Threading, Priority, and Fibers, Creating a Cold Standby
log shipping in, Creating a Cold Standby
performance boost with fibers, Configuring Threading, Priority, and Fibers
supports AWE memory, Using Fixed Memory
Enterprise Manager, Configuring SQL Server with SQL Server Management Studio
error message alerts, Managing Alerts
error reporting, Managing the Services Configuration, Setting the Startup Service Account
ETL (extraction, transformation, and loading), Deploying Microsoft SQL Server 2005, Installing a SQL Server Instance, Importing, Exporting, and Transforming Data
event classes, Configuring Alerts for Performance Counters
event forwarding, Copying Alerts, Operators, and Scheduled Jobs from One Server to Another
event logs, Monitoring Tools and Resources, Adding Publishers and Publisher Groups, Examining the Application Log, Examining the SQL Server Event Logs
SQL Server, Examining the Application Log
SQL Server Agent, Examining the SQL Server Event Logs
Event Viewer, Managing the Enterprise, Working with the Event Logs
Exchange gateway, Installing a SQL Server Instance
Execute Package Utility (dtexecui), Integration Services Tools, Stage 4: Save and Execute
execute-time options, Setting Configuration Options
Express Edition, Microsoft SQL Server 2005 Editions, Determining System and Server Information, Database Files and Logs, Modifying Databases Using ALTER DATABASE
Auto Close in, Modifying Databases Using ALTER DATABASE
database size in, Database Files and Logs
Extended Properties Catalog views, Accessing SQL Server Configuration Data
Extensible Markup Language, Using SQL Server Integration Services (see )
extents, Getting Started with Tables, Understanding Data Pages
extraction, transformation, and loading (ETL), Deploying Microsoft SQL Server 2005, Installing a SQL Server Instance, Importing, Exporting, and Transforming Data

F

failover clustering, Microsoft SQL Server 2005 Editions, Creating a Cold Standby
fail-safe operator, Deleting and Disabling Notification for Operators
failure recovery, Configuring the I/O Subsystem
(see also )
FAT (File Allocation Table), Database Files and Logs
FC (Fiber Channel), SQL Server 2005 and Your Hardware
feature reports, Setting the Startup Service Account
federation, Using Views
Fiber Channel (FC), SQL Server 2005 and Your Hardware
fibers, Setting Parallel Processing, Setting Parallel Processing, Setting Parallel Processing
configuring, Setting Parallel Processing
switching, Setting Parallel Processing
fields, Using Native Data Types
File Allocation Table (FAT), Database Files and Logs
filegroups, Viewing Database Information Using T-SQL, Creating Databases in SQL Server Management Studio, Creating Databases in SQL Server Management Studio, Setting Online, Offline, or Emergency Mode, Preventing Transaction Log Errors, Understanding Data Pages, Restoring a Database from a Normal Backup
multiple, Creating Databases in SQL Server Management Studio
online vs. offline, Setting Online, Offline, or Emergency Mode
place table partitions into, Understanding Data Pages
preventing Filegroup Is Full error, Preventing Transaction Log Errors
restoring, Restoring a Database from a Normal Backup
fixed database roles, Database Roles
fixed memory, Working with Dynamically Configured Memory
fixed-length fields, Using Native Data Types
flat files, Server-Based Connections to SQL Server
foreign key constraints, Using the Database Engine Tuning Advisor, Using Foreign Key Constraints
foreign keys, Preparing for Transactional Replication
full recovery model, Managing Cross-Database Chaining and External Access Options, Initial Backup and Recovery Planning
Full-text catalogs, Working with Full-Text Search, Working with Full-Text Search, Editing Indexing of Tables and Views, Database Files and Logs, Checking System and Sample Databases, Attaching and Detaching Databases, Copying and Moving Databases, Moving Databases, Initial Backup and Recovery Planning, Log Truncation Options, Restoring Full-Text Catalogs
backing up, Initial Backup and Recovery Planning, Log Truncation Options
managing, Working with Full-Text Search
moving, Moving Databases
preserving during copy/move, Copying and Moving Databases
populating, Editing Indexing of Tables and Views
restoring, Restoring Full-Text Catalogs
Full-Text Engine for SQL, Microsoft SQL Server 2005 Editions
Full-text indexes, Using the Graphical Administration Tools, Editing Indexing of Tables and Views, Creating Databases in SQL Server Management Studio
disabling and removing from tables and views, Editing Indexing of Tables and Views
Full-Text Search, Managing the Services Configuration, Working with System Stored Procedures, Starting, Stopping, and Configuring the Microsoft Distributed Transaction Coordinator, Working with Full-Text Search, Restoring Full-Text Catalogs
stored procedures, Working with System Stored Procedures
working with, Working with Full-Text Search

G

General Extended Stored Procedures, Working with System Stored Procedures
globally unique identifiers, Allowing and Disallowing Nulls
granular permissions, Server Roles, Database Roles, Creating Schemas
graphical administration tools, Service Accounts for SQL Server
(see also individual tool names)
Group Policy, Enabling AWE Memory Support
Group Policy Attachment Manager, Performing the Initial Database Mail Configuration
guest user, Working with the NETWORK SERVICE and SYSTEM Logins

H

handles, Ensuring Connectivity and Data Access
hardware, guidelines for choosing, Microsoft SQL Server 2005 Administration Overview
hot standby servers, Initial Backup and Recovery Planning, Restoring the Master Database

I

identifiers, Creating Databases in SQL Server Management Studio, Working with Schemas, Getting Started with Tables
identities, Allowing and Disallowing Nulls
identity property, Creating User-Defined Data Types
implicit permissions, Working with the dbo User
implied permissions, Statement Permissions
index fill, Configuring Year 2000 Support
index locks, Understanding Indexes
indexed views, Managing Database Compatibility
indexes, Enabling AWE Memory Support, Setting the Index Fill, Setting the Index Fill, Checking System and Sample Databases, Getting Started with Tables, Managing Views, Managing Views, Understanding Indexes, Understanding Indexes, Understanding Indexes, Understanding Indexes, Understanding Indexes, Understanding Indexes, Understanding Indexes, Understanding Indexes, Understanding Indexes, Understanding Indexes, Using XML Indexes, Using XML Indexes, Using XML Indexes, Indexing Computed Columns and Views, Viewing Index Properties, Managing Indexes, Stage 3: Formatting and Transformation
clustered, Setting the Index Fill, Understanding Indexes, Understanding Indexes, Using XML Indexes, Stage 3: Formatting and Transformation
creating, Enabling AWE Memory Support, Viewing Index Properties
determining columns to index, Using XML Indexes
improve performance, Understanding Indexes
locks, Understanding Indexes
managing, Managing Indexes
nonclustered, Setting the Index Fill, Understanding Indexes, Understanding Indexes, Using XML Indexes
online, Understanding Indexes
partitioning, Understanding Indexes
understanding, Managing Views
viewing properties, Indexing Computed Columns and Views
XML, Understanding Indexes, Understanding Indexes
indexing, Creating Catalogs, Enabling Indexing of Tables and Views, Editing Indexing of Tables and Views, Enabling AWE Memory Support, Indexing Computed Columns and Views, Indexing Computed Columns and Views
computed columns and views, Indexing Computed Columns and Views
disabling and removing, Editing Indexing of Tables and Views
editing, Enabling Indexing of Tables and Views
enabling for tables and views, Creating Catalogs
optimizing memory for, Enabling AWE Memory Support
Information Schema views, Configuring and Tuning Microsoft SQL Server
Integration Services Server, Service Accounts for SQL Server
Integration Services Service, Integration Services Tools
Integration Services, Other Command-Line Tools (see )
I/O affinity, Allocating Memory for Queries
I/O error checking, Managing Cross-Database Chaining and External Access Options
I/O subsystem, Using SQL Server 2005 for Multidimensional Databases and Data Mining

J

jobs, Scheduling Jobs, Scheduling Jobs, Scheduling Jobs, Assigning or Changing Job Definitions, Assigning or Changing Job Definitions, Setting Steps to Execute, Configuring Job Schedules, Handling Job Alerts, Handling Job Alerts, Handling Job Alerts, Handling Notification Messages, Copying Alerts, Operators, and Scheduled Jobs from One Server to Another
alerts, Handling Job Alerts
assigning or changing definitions, Scheduling Jobs
categories, Assigning or Changing Job Definitions, Handling Notification Messages
configuring schedules, Setting Steps to Execute
copying, Copying Alerts, Operators, and Scheduled Jobs from One Server to Another
creating, Scheduling Jobs
notification messages, Handling Job Alerts
recurring, Configuring Job Schedules
scheduling, Scheduling Jobs
steps to execute, Assigning or Changing Job Definitions

K

kernel mode, Setting Parallel Processing
keys, Checking System and Sample Databases
keywords, Working with Security Principals and Securables
(see also )

L

Linear Tape Open (LTO), Selecting Backup Devices and Media
Linked Servers Catalog views, Working with the System Catalog and Catalog Views
linked servers, Linked Servers and Distributed Transactions, Running the Distributed Transaction Coordinator Service, Adding Linked Servers, Configuring Security for Linked Servers, Setting Server Options for Remote and Linked Servers
adding, Running the Distributed Transaction Coordinator Service
deleting, Setting Server Options for Remote and Linked Servers
security for, Adding Linked Servers
server options, Configuring Security for Linked Servers
local loopback address, Configuring the Named Pipes Network Configuration
local system accounts, Services for SQL Server, Setting the Startup Service Account, Setting the Startup Service Account
Lock Pages In Memory user privilege, Enabling AWE Memory Support
locks, Tracking Locks by Process ID and Object, Tracking Locks by Process ID and Object, Tracking Locks by Process ID and Object
in database administration, Tracking Locks by Process ID and Object
tracking, Tracking Locks by Process ID and Object
Log Reader Agent, Replication Components, Preparing for Snapshot Replication, Snapshot and Transactional Publications, Snapshot and Transactional Publications, Setting Publication Properties
log shipping, Microsoft SQL Server 2005 Editions, Ensuring Availability and Scalability, Working with System Stored Procedures, Working with System Stored Procedures, Viewing Database Information in SQL Server Management Studio, Initial Backup and Recovery Planning, Initial Backup and Recovery Planning, Planning for Mirroring and Mirrored Database Backups, Overview of Database Automation and Maintenance, Overview of Database Automation and Maintenance, Using DBCC CHECKCATALOG, Upgrading SQL Server 2000 Log Shipping to SQL Server 2005 Log Shipping, Adding Log Shipping Secondaries, Failing Over to a Secondary Database
adding secondaries, Adding Log Shipping Secondaries
alternative to database mirroring, Overview of Database Automation and Maintenance
enabling on primary database, Upgrading SQL Server 2000 Log Shipping to SQL Server 2005 Log Shipping
managing, Using DBCC CHECKCATALOG
stored procedures, Working with System Stored Procedures
to create standby servers, Initial Backup and Recovery Planning
log size, Viewing, Changing, and Overriding Database Options, Viewing, Changing, and Overriding Database Options, Viewing, Changing, and Overriding Database Options, Renaming a Database
expanding manually, Viewing, Changing, and Overriding Database Options
managing, Viewing, Changing, and Overriding Database Options
remove before dropping database, Renaming a Database
log truncation, Log Truncation Options
logging options, Managing Cross-Database Chaining and External Access Options
logins, Windows Authentication, Windows Authentication, Special Purpose Logins and Users, Special Purpose Logins and Users, Working with the NETWORK SERVICE and SYSTEM Logins, Working with the NETWORK SERVICE and SYSTEM Logins, Database Roles, Database Roles, Viewing and Editing Existing Logins, Creating Logins, Granting or Denying Server Access, Granting or Denying Server Access, Enabling, Disabling, and Unlocking Logins, Revoking Access Rights and Roles by Server Login, Assigning Roles for Multiple Logins
assigning access and roles by, Revoking Access Rights and Roles by Server Login
assigning roles for multiple, Assigning Roles for Multiple Logins
creating, Viewing and Editing Existing Logins
domain, Special Purpose Logins and Users
editing with T-SQL, Creating Logins
enabling, disabling, and unlocking, Granting or Denying Server Access
granting or denying, Granting or Denying Server Access
managing, Database Roles
NETWORK SERVICE, Working with the NETWORK SERVICE and SYSTEM Logins
removing, Enabling, Disabling, and Unlocking Logins
server, Special Purpose Logins and Users
special purpose, Windows Authentication
SYSTEM, Working with the NETWORK SERVICE and SYSTEM Logins
viewing and editing existing, Database Roles
LTO (Linear Tape Open), Selecting Backup Devices and Media

M

managed code, Using SQL Server Integration Services, Installing a SQL Server Instance
Managed Reporting, Using SQL Server 2005 for Multidimensional Databases and Data Mining
MAPI. (Messaging Application Programming Interface), Setting the SQL Server Agent Mail Profile
MARS (multiple active result sets), Ensuring Connectivity and Data Access, Techniques for Managing SQL Server Configuration Options, Setting Configuration Options
master database, Changing Collation and Rebuilding the Master Database, Viewing Database Information Using T-SQL, Renaming a Database, Dropping and Deleting a Database, Attaching a Database with Only Data Files, Working with the NETWORK SERVICE and SYSTEM Logins, Working with the dbo User, Replication Components, Initial Backup and Recovery Planning, Initial Backup and Recovery Planning, Initial Backup and Recovery Planning, Planning for Mirroring and Mirrored Database Backups, Selecting Backup Devices and Media, Creating a New Backup Set, Restoring Full-Text Catalogs, Restoring Full-Text Catalogs
backing up, Renaming a Database, Dropping and Deleting a Database, Planning for Mirroring and Mirrored Database Backups, Selecting Backup Devices and Media, Creating a New Backup Set
cannot mirror, Initial Backup and Recovery Planning
rebuilding, Changing Collation and Rebuilding the Master Database, Restoring Full-Text Catalogs
restoring, Restoring Full-Text Catalogs
use simple recovery model, Initial Backup and Recovery Planning
max-length fields, Using Native Data Types
media set, Using Striped Backups with Multiple Devices, Using Striped Backups with Multiple Devices, Using Striped Backups with Multiple Devices
adding to, Using Striped Backups with Multiple Devices
creating new, Using Striped Backups with Multiple Devices
memory, Microsoft SQL Server 2005 Administration Overview, Setting Authentication Mode, Tuning Memory Usage, Working with Dynamically Configured Memory, Working with Dynamically Configured Memory, Enabling AWE Memory Support, Optimizing Memory for Indexing
allocating for queries, Optimizing Memory for Indexing
dynamically configured, Tuning Memory Usage
fixed, Working with Dynamically Configured Memory
optimizing for indexing, Enabling AWE Memory Support
physical, Working with Dynamically Configured Memory
tuning usage, Setting Authentication Mode
Merge Agent, Replication Components, Preparing for Merge Replication, Subscription Essentials, Setting Steps to Execute
Messages (for Errors) Catalog views, Working with the System Catalog and Catalog Views
Messaging Application Programming Interface (MAPI), Setting the SQL Server Agent Mail Profile
messaging, Microsoft SQL Server 2005 Administration Overview
metadata repository, Using SQL Server Integration Services
Microsoft .NET Framework, Microsoft SQL Server 2005 Administration Overview, Using SQL Server Integration Services, Ensuring Connectivity and Data Access, Installing a SQL Server Instance, Managing SQL Server Component Feature Access, Managing SQL Server Component Feature Access, Working with Integration Services, Integration Services Tools, Stage 1: Source and Destination Configuration
Microsoft Access, Integration Services Tools, Stage 1: Source and Destination Configuration, Adding Linked Servers
Microsoft Cluster service, Ensuring Availability and Scalability
Microsoft Data Mining Services, Integration Services Tools, Stage 1: Source and Destination Configuration, File-Based Data Connections
Microsoft Distributed Transaction Coordinator (MS DTC), Starting, Stopping, and Configuring SQL Server Agent, Configuring Remote Server Connections, Using Distributed Transactions
executing stored procedures and queries, Configuring Remote Server Connections
starting, stopping, and configuring, Starting, Stopping, and Configuring SQL Server Agent
Microsoft Download Center, Creating New Instances of SQL Server
Microsoft Excel, Integration Services Tools, Stage 1: Source and Destination Configuration, File-Based Data Connections, Adding Linked Servers
Microsoft Exchange, Using Database Mail
Microsoft Internet Publishing, Integration Services Tools, Stage 1: Source and Destination Configuration
Microsoft OLE DB Provider, Techniques for Managing SQL Server Configuration Options, Integration Services Tools, Stage 1: Source and Destination Configuration, Server-Based Connections to Databases Other Than SQL Server, Server-Based Connections to SQL Server, Linked Servers and Distributed Transactions, Adding Linked Servers
connect to SQL Server, Server-Based Connections to SQL Server
linked servers depend on, Linked Servers and Distributed Transactions
parameter values for configuring, Adding Linked Servers
Microsoft Online Support Web site, Database Corruption and Problem Resolution
Microsoft Outlook, Setting the SQL Server Agent Mail Profile
Microsoft Reporting Services, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Other Command-Line Tools, Using SQL Server 2005 for Multidimensional Databases and Data Mining, Installing a SQL Server Instance, Installing a SQL Server Instance, Managing the Services Configuration, Managing SQL Server Component Feature Access, Managing SQL Server Component Feature Access
Microsoft Search Service, Starting, Stopping, and Configuring the Microsoft Distributed Transaction Coordinator, Working with Full-Text Search, Working with Full-Text Search
Microsoft SharePoint Portal Server, Using SQL Server 2005 for Multidimensional Databases and Data Mining
Microsoft SQL Server 2005 Notification Services, Working with System Stored Procedures
Microsoft SQL Server 2005, Configuring and Tuning Microsoft SQL Server (see )
Microsoft Windows 2000 Advanced Server, Microsoft SQL Server 2005 Editions
Microsoft Windows 2000 Datacenter Server, Microsoft SQL Server 2005 Editions
Microsoft Windows 2000, Managing the Network and SQL Native Client Configuration
Microsoft Windows 95, Determining System and Server Information
Microsoft Windows 98, Managing the Network and SQL Native Client Configuration, Configuring the TCP/IP Native Client Configuration, Determining System and Server Information
Microsoft Windows authentication, Installing a SQL Server Instance (see )
Microsoft Windows collation names, Creating Databases in SQL Server Management Studio
Microsoft Windows Installer 3.0, Creating New Instances of SQL Server
Microsoft Windows NT, Managing the Network and SQL Native Client Configuration, Configuring the TCP/IP Native Client Configuration
Microsoft Windows Server 2003 Administrator’s Pocket Consultant, 2nd ed., BCP Scripts, Preparing for Log Shipping
Microsoft Windows Server 2003 Service Pack 1, Managing the Network and SQL Native Client Configuration (see )
Microsoft Windows Server 2003, Managing the Network and SQL Native Client Configuration (see )
Microsoft Windows XP Administrator’s Pocket Consultant, 2nd ed., BCP Scripts
Microsoft Windows XP Professional Service Pack 2, Managing the Network and SQL Native Client Configuration (see )
Microsoft Windows XP Professional, Managing the Network and SQL Native Client Configuration (see )
mirror server, Initial Backup and Recovery Planning, Configuring Mirroring
mirroring server, Ensuring Availability and Scalability
mirroring, Microsoft SQL Server 2005 Editions (see )
Mixed Mode authentication, Installing a SQL Server Instance
Mobile Edition, Microsoft SQL Server 2005 Editions, Snapshot and Transactional Publications
model database, Database Files and Logs, Viewing Database Information Using T-SQL, Creating Databases, Creating Databases in SQL Server Management Studio, Altering Databases and Their Options, Compressing and Shrinking a Database Manually, Attaching a Database with Only Data Files, Moving Databases, Preventing Transaction Log Errors, Working with the NETWORK SERVICE and SYSTEM Logins, Working with the NETWORK SERVICE and SYSTEM Logins, Creating User-Defined Data Types, Replication Components, Initial Backup and Recovery Planning, Initial Backup and Recovery Planning, Initial Backup and Recovery Planning
cannot mirror, Initial Backup and Recovery Planning
template for new databases, Preventing Transaction Log Errors, Working with the NETWORK SERVICE and SYSTEM Logins, Initial Backup and Recovery Planning
uses full recovery model, Initial Backup and Recovery Planning
MS DTC, Using Distributed Transactions (see )
msdb database, Checking System and Sample Databases, Renaming a Database, Attaching a Database with Only Data Files, Integration Services Tools, Stage 4: Save and Execute, Replication Components, Initial Backup and Recovery Planning, Initial Backup and Recovery Planning, Planning for Mirroring and Mirrored Database Backups
backing up, Planning for Mirroring and Mirrored Database Backups
cannot mirror, Initial Backup and Recovery Planning
deleting backup and history information from, Renaming a Database
Integration Services packages stored in, Integration Services Tools
packages stored in, Stage 4: Save and Execute
use simple recovery model, Initial Backup and Recovery Planning
multidimensional databases, Using SQL Server Integration Services
multimode server clusters, Creating New Instances of SQL Server
multiple active result sets (MARS), Ensuring Connectivity and Data Access, Techniques for Managing SQL Server Configuration Options, Setting Configuration Options
multiserver administration, Copying Alerts, Operators, and Scheduled Jobs from One Server to Another, Multiserver Job Scheduling, Multiserver Job Scheduling
configuring master servers, Multiserver Job Scheduling
job scheduling, Multiserver Job Scheduling
multitasking, Allocating Memory for Queries

N

Named Pipes protocol, Managing the Connections Configuration, Managing the Connections Configuration, Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting, Managing the Network and SQL Native Client Configuration, Configuring the TCP/IP Native Client Configuration
configuring, Managing the Network and SQL Native Client Configuration
native client configuration, Configuring the TCP/IP Native Client Configuration
names, Working with Schemas, Working with Schemas, Understanding Table Partitions
schemas, Working with Schemas
tables, Understanding Table Partitions
namespace, Working with Schemas, Modifying Schemas
native data types, Using Native Data Types, Using Native Data Types, Using Native Data Types
for dates, characters, and binary values, Using Native Data Types
for numbers and money, Using Native Data Types
Native Web Services, Managing SQL Server Component Feature Access
nested triggers allowing and disallowing, Allowing and Disallowing System Updates
.NET Framework, Microsoft SQL Server 2005 Administration Overview, Using SQL Server Integration Services, Ensuring Connectivity and Data Access, Installing a SQL Server Instance, Managing SQL Server Component Feature Access, Managing SQL Server Component Feature Access, Working with Integration Services, Integration Services Tools, Stage 1: Source and Destination Configuration
network interface cards (NICs), Optimizing CPU Usage
NICs. (network interface cards), Optimizing CPU Usage
nonclustered, Setting the Index Fill, Understanding Indexes, Understanding Indexes, Using XML Indexes
notification messages, Handling Job Alerts
Notification Services, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Other Command-Line Tools, Installing a SQL Server Instance, Installing a SQL Server Instance, Working with System Stored Procedures, Getting Started with SQL Server Management Studio
NT File System (NTFS), Database Files and Logs
NTFS (NT File System), Database Files and Logs
nulls, Creating User-Defined Data Types, Creating User-Defined Data Types, Allowing and Disallowing Nulls, Stage 3: Formatting and Transformation
allowing and disallowing, Creating User-Defined Data Types, Stage 3: Formatting and Transformation
use is controversial, Allowing and Disallowing Nulls
numeric data type, Using Native Data Types

O

Object Explorer view, Service Accounts for SQL Server, Using SQL Server Management Studio for Queries
object linking and embedding database, SQLCMD (see )
object permissions, Working with the dbo User, Object Permissions by Login, Object Permissions by Login
by login, Object Permissions by Login
for multiple logins, Object Permissions by Login
Objects catalog views, Working with the System Catalog and Catalog Views
Objects catalog views, Accessing SQL Server Configuration Data
objects, Checking System and Sample Databases, Modifying Schemas, Copying Users, Tables, Views, and Other Objects from One Database to Another, Copying Users, Tables, Views, and Other Objects from One Database to Another
copying, Copying Users, Tables, Views, and Other Objects from One Database to Another
database, Checking System and Sample Databases
moving to new schema, Modifying Schemas
ODBC, Ensuring Connectivity and Data Access (see )
OEM (original equipment manufacturer), Importing and Exporting Flat Files
OLAP (Online Analytical Processing), Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Using SQL Server Integration Services, File-Based Data Connections
OLE Automation, Managing SQL Server Component Feature Access, Working with System Stored Procedures
OLE DB (object linking and embedding database), SQLCMD, Ensuring Connectivity and Data Access, Configuring and Tuning Microsoft SQL Server, Setting Configuration Options, Starting, Stopping, and Configuring SQL Server Agent, Setting Maximum User Connections
connection properties, Setting Configuration Options
default state, Setting Maximum User Connections
schema rowsets, Configuring and Tuning Microsoft SQL Server
updating data on multiple OLE DB data sources, Starting, Stopping, and Configuring SQL Server Agent
Online Analytical Processing (OLAP), Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Using SQL Server Integration Services, File-Based Data Connections
Open Database Connectivity (ODBC), Ensuring Connectivity and Data Access, Ensuring Connectivity and Data Access, Configuring and Tuning Microsoft SQL Server, Techniques for Managing SQL Server Configuration Options, Setting Configuration Options, Setting Maximum User Connections, Integration Services Tools, Stage 1: Source and Destination Configuration, Stage 4: Save and Execute
BCP uses, Stage 4: Save and Execute
catalog functions, Configuring and Tuning Microsoft SQL Server
connection properties, Setting Configuration Options
default, Setting Maximum User Connections
driver properties, Techniques for Managing SQL Server Configuration Options
operating system commands, Setting Steps to Execute
operators, Handling Alert Responses, Handling Alert Responses, Registering Operators, Registering Operators, Deleting and Disabling Notification for Operators, Copying Alerts, Operators, and Scheduled Jobs from One Server to Another
copying, Copying Alerts, Operators, and Scheduled Jobs from One Server to Another
deleting and disabling notification for, Registering Operators
fail-safe, Deleting and Disabling Notification for Operators
pager account, Registering Operators
registering, Handling Alert Responses
optical jukeboxes, Selecting Backup Devices and Media
Oracle, Integration Services Tools, Stage 1: Source and Destination Configuration, File-Based Data Connections, Server-Based Connections to Databases Other Than SQL Server, Adding Linked Servers, Creating Publications, Adding Publishers and Publisher Groups
New Oracle Publication Wizard, Creating Publications
publisher, Adding Publishers and Publisher Groups
original equipment manufacturer (OEM), Importing and Exporting Flat Files
ownership chaining, Setting Online, Offline, or Emergency Mode, Attaching and Detaching Databases

P

page faults per second, Setting Authentication Mode
pager account, Registering Operators
parallel backup and restore, Planning for Backups of Replicated Databases
parallel processing, Allocating Memory for Queries, Replication Agents and Jobs, Preparing for Snapshot Replication
parallel queries, SQL Server 2005 and Your Hardware
parallel striped backups, Adding to an Existing Backup Set
parallelism, Enabling AWE Memory Support
Partition Function Catalog views, Working with the System Catalog and Catalog Views
partitioned views, Using Views
partitioning strategies, Using the Database Engine Tuning Advisor
partitions in tables, Understanding Data Pages
passwords, Installing a SQL Server Instance, Changing Passwords, Changing Passwords
changing, Changing Passwords
strong, Installing a SQL Server Instance
Performance Monitor, Managing the Enterprise (see )
permission keywords, Working with Security Principals and Securables
permissions, Overview of SQL Server 2005 Security, Examining Permissions Granted to Securables, Examining Permissions Granted to Securables, Examining Built-in Permissions, Working with the dbo User, Working with the dbo User, Statement Permissions, Statement Permissions, Server Roles, Database Roles, Managing Database Permissions, Object Permissions by Login, Creating Schemas, Creating Schemas, Viewing Table Row and Size Information
built-in, Examining Permissions Granted to Securables
configuring for user or role, Creating Schemas
effective, Examining Built-in Permissions
granted to securables, Examining Permissions Granted to Securables
granular, Server Roles, Database Roles, Creating Schemas
implied, Statement Permissions
managing, Managing Database Permissions
object, Working with the dbo User, Object Permissions by Login
statement, Statement Permissions
table, Viewing Table Row and Size Information
per-server licensing, Microsoft SQL Server 2005 Editions
precision, Using Native Data Types
predefined (or fixed) database roles, Server Roles, Database Roles
primary key constraints, Using the Database Engine Tuning Advisor, Setting Unique Constraints
primary keys, Getting Started with Tables, Creating User-Defined Data Types, Allowing and Disallowing Nulls, Preparing for Snapshot Replication, Snapshot and Transactional Publications, Merge Publications
principal server, Ensuring Availability and Scalability, Initial Backup and Recovery Planning, Configuring Mirroring
priority, Setting Parallel Processing
proactive caching, Using SQL Server 2005 for Multidimensional Databases and Data Mining
process account, Creating Subscriptions
process information, Removing Catalogs, Examining Process Information, Troubleshooting Deadlocks and Blocking Connections
examining, Removing Catalogs
used in database administration, Examining Process Information
processor affinity, Allocating Memory for Queries
processors, Allocating Memory for Queries
public role, Overview of SQL Server 2005 Security, Examining Built-in Permissions
public server role, Working with the NETWORK SERVICE and SYSTEM Logins
Publication Access List, Creating Subscriptions
publication databases, Enabling and Updating Publishers, Planning for Mirroring and Mirrored Database Backups, Planning for Backups of Replicated Databases
publications, An Overview of Replication, Deleting Distribution Databases, Creating Publications, Creating Publications, Snapshot and Transactional Publications, Viewing and Updating Publications, Viewing and Updating Publications, Setting Agent Security and Process Accounts, Setting Agent Security and Process Accounts, Creating a Script for a Publication, Creating a Script for a Publication
ACLs in, Setting Agent Security and Process Accounts
creating, Deleting Distribution Databases
deleting, Creating a Script for a Publication
merge, Snapshot and Transactional Publications
properties, Viewing and Updating Publications
scripts, Setting Agent Security and Process Accounts
snapshot, Creating Publications
subscribing to, Creating a Script for a Publication
transactional, Creating Publications
viewing and updating, Viewing and Updating Publications
publisher groups, Adding Publishers and Publisher Groups
publishers, Creating Distribution Databases

Q

queries, Working with System Stored Procedures, Executing Queries and Changing Settings, Allocating Memory for Queries, Allocating Memory for Queries, Setting Parallel Processing, Setting Parallel Processing, Configuring Remote Server Connections, Allowing and Disallowing Nested Triggers, Building a Query
(see also )
allocating memory for, Allocating Memory for Queries
building, Building a Query
complex, Setting Parallel Processing
executing, Executing Queries and Changing Settings, Allowing and Disallowing Nested Triggers
handled as distributed transactions, Configuring Remote Server Connections
large, Setting Parallel Processing
parallel, Allocating Memory for Queries
Query Designer, Building a Query
Query Editor, Copying Users, Tables, Views, and Other Objects from One Database to Another
query optimizer, Setting Online, Offline, or Emergency Mode, Using Views
query processor, Using Views
Query view, Managing the Configuration with SQL Server Management Studio, Determining System and Server Information, Allowing and Disallowing Nested Triggers, Viewing Database Information in SQL Server Management Studio, Modifying Databases Using ALTER DATABASE, Compressing and Shrinking a Database Manually, Creating a Script for a Publication
access scripts in, Creating a Script for a Publication
executing commands in, Compressing and Shrinking a Database Manually
viewing database information in, Viewing Database Information in SQL Server Management Studio
Queue Reader Agent, Replication Agents and Jobs, Replication Variants, Snapshot and Transactional Publications, Snapshot and Transactional Publications, Setting Publication Properties, Setting Steps to Execute
pass Transact-SQL commands to, Setting Steps to Execute
setting security in, Setting Publication Properties
queues, Microsoft SQL Server 2005 Administration Overview

R

RAID (redundant array of independent disks), SQL Server 2005 and Your Hardware, Building the Server System for Performance, Configuring the I/O Subsystem, Creating Secondary Data and Log Files
hardware vs. software, Building the Server System for Performance
levels of, Configuring the I/O Subsystem
Rebuild utility, Changing Collation and Rebuilding the Master Database
recovery, Managing Cross-Database Chaining and External Access Options, Backing Up and Recovering SQL Server 2005, Backing Up and Recovering SQL Server 2005, Initial Backup and Recovery Planning, Restoring a Database to a Different Location
creating plan, Backing Up and Recovering SQL Server 2005
missing data, Restoring a Database to a Different Location
three options, Managing Cross-Database Chaining and External Access Options, Initial Backup and Recovery Planning
redundant array of independent disks, SQL Server 2005 and Your Hardware (see )
Registered Servers view, Using the Graphical Administration Tools, Managing SQL Server Groups, Copying Server Groups and Registration Details from One Computer to Another, Copying Server Groups and Registration Details from One Computer to Another
registration properties, Copying Server Groups and Registration Details from One Computer to Another
Relational Data warehouses, Deploying Microsoft SQL Server 2005, Using SQL Server Integration Services
remote connections, Configuring Threading, Priority, and Fibers
Remote Procedure Call (RPC) connections, Configuring Remote Server Connections, Using Distributed Queries, Adding Linked Servers
remote servers, Configuring Security for Linked Servers
remote stored procedure calls, Linked Servers and Distributed Transactions
removable disks, Selecting Backup Devices and Media
replication agents, Replication Components
(see also individual agent names)
Replication Monitor, Setting Up a New Distributor, Monitoring Tools and Resources, Monitoring Tools and Resources
Replication Services, Checking System and Sample Databases
replication, Ensuring Availability and Scalability, Ensuring Availability and Scalability, Ensuring Availability and Scalability, Ensuring Availability and Scalability, Getting Started with SQL Server Management Studio, Linked Servers and Distributed Transactions, Implementing Snapshot, Merge, and Transactional Replication, Implementing Snapshot, Merge, and Transactional Replication, An Overview of Replication, Replication Components, Replication Agents and Jobs, Replication Agents and Jobs, Replication Variants, Replication Variants, Replication Variants, Replication Variants, Replication Models, Preparing for Snapshot Replication, Preparing for Transactional Replication, Creating Publications, Creating Publications, Creating Publications, Initial Backup and Recovery Planning, Planning for Backups of Replicated Databases, Planning for Backups of Replicated Databases, Setting Steps to Execute, Setting Steps to Execute
agents and jobs, Replication Components
components, An Overview of Replication
merge, Ensuring Availability and Scalability, Replication Variants, Preparing for Transactional Replication, Creating Publications, Planning for Backups of Replicated Databases, Setting Steps to Execute
models, Replication Variants
overview of, Implementing Snapshot, Merge, and Transactional Replication
planning for, Replication Variants
reasons to use, Implementing Snapshot, Merge, and Transactional Replication
snapshot, Ensuring Availability and Scalability, Replication Agents and Jobs, Replication Models, Creating Publications, Setting Steps to Execute
transactional, Ensuring Availability and Scalability, Replication Variants, Preparing for Snapshot Replication, Creating Publications, Planning for Backups of Replicated Databases
variants, Replication Agents and Jobs
Report Builder, Managing SQL Server Component Feature Access
Report Manager, Microsoft SQL Server 2005 Administration Overview, Using the Graphical Administration Tools, Installing a SQL Server Instance, Managing SQL Server Component Feature Access
Report Server services, Creating New Instances of SQL Server
Report Server Web Application, Using SQL Server 2005 for Multidimensional Databases and Data Mining
Report Server Web service, Managing SQL Server Component Feature Access, Managing SQL Server Component Feature Access
Report Server, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Service Accounts for SQL Server, Other Command-Line Tools, Installing a SQL Server Instance, Installing a SQL Server Instance, Managing the Services Configuration, Working with the NETWORK SERVICE and SYSTEM Logins
Report Services, Installing a SQL Server Instance, Managing SQL Server Component Feature Access
Report view, Working with Dynamically Configured Memory
Reporting Services, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Other Command-Line Tools, Using SQL Server 2005 for Multidimensional Databases and Data Mining, Installing a SQL Server Instance, Installing a SQL Server Instance, Managing the Services Configuration, Managing SQL Server Component Feature Access, Managing SQL Server Component Feature Access
Resource database files, Copying and Moving Databases
resource managers, Using Distributed Queries
restore time-out, Setting the Index Fill
retention period, Configuring Backup and Restore Time-Out Options
role memberships, Removing Role Memberships for Database Users, Working with Schemas
roles, Managing SQL Server 2005 Security, Examining Built-in Permissions, Working with the dbo User, Implied Permissions, Implied Permissions, Server Roles, Server Roles, Database Roles, Changing Passwords, Creating Standard Database Roles, Removing Role Memberships for Database Users
database roles, Server Roles, Creating Standard Database Roles
deleting user-defined, Removing Role Memberships for Database Users
fixed database roles, Database Roles
fixed server roles, Server Roles
server roles, Implied Permissions, Changing Passwords
RPC (Remote Procedure Call) connections, Configuring Remote Server Connections, Using Distributed Queries, Adding Linked Servers
Rules, Using Check Constraints

S

sa login, Special Purpose Logins and Users
sample databases, Viewing Database Information Using T-SQL, Checking System and Sample Databases
installation, Checking System and Sample Databases
sampling, Configuring Alerts for Performance Counters
SANs (storage area networks), Configuring the I/O Subsystem
Scalar Types Catalog views, Working with the System Catalog and Catalog Views
scale, Using Native Data Types
Schemas Catalog views, Working with the System Catalog and Catalog Views
schemas, Managing SQL Server 2005 Security, Examining Effective Permissions, Working with the dbo User, Working with the dbo User, Manipulating Schemas, Tables, Indexes, and Views, Manipulating Schemas, Tables, Indexes, and Views, Manipulating Schemas, Tables, Indexes, and Views, Working with Schemas, Working with Schemas, Working with Schemas, Creating Schemas, Creating Schemas, Creating Schemas, Moving Objects to a New Schema, Working with Views, Replication Components
benefits, Working with Schemas
creating, Working with Schemas
dropping, Moving Objects to a New Schema
INFORMATION_SCHEMA, Working with the dbo User
modifying, Creating Schemas
naming, Working with Schemas
objects, Examining Effective Permissions, Manipulating Schemas, Tables, Indexes, and Views, Replication Components
owners, Creating Schemas, Creating Schemas
sys, Working with the dbo User
views contained in, Working with Views
working with, Manipulating Schemas, Tables, Indexes, and Views
scopes, Overview of SQL Server 2005 Security, Working with Security Principals and Securables, Working with Security Principals and Securables, Working with Security Principals and Securables
securable scopes, Working with Security Principals and Securables
SQL Server securable scopes, Working with Security Principals and Securables
understanding permissions of, Working with Security Principals and Securables
Script Wizard, Copying Users, Tables, Views, and Other Objects from One Database to Another
scripts, Adding and Removing Columns in a Table, Importing Data with BCP, Importing Data with BCP, Setting Steps to Execute
BCP, Importing Data with BCP
changes to, Setting Steps to Execute
tables, Adding and Removing Columns in a Table
secondary data and log files creating, Moving and Resizing tempdb
secondary server, Initial Backup and Recovery Planning
securables, Overview of SQL Server 2005 Security
Security Catalog views, Working with the System Catalog and Catalog Views
Security Identifier (SID), Overview of SQL Server 2005 Security
security principals, Overview of SQL Server 2005 Security, Overview of SQL Server 2005 Security, Creating Schemas
levels, Overview of SQL Server 2005 Security
schema owners as, Creating Schemas
security, Managing the Connections Configuration, Managing the Connections Configuration, Working with System Stored Procedures, Determining System and Server Information, Windows Authentication, Database Roles
mixed, Windows Authentication, Database Roles
stored procedures, Working with System Stored Procedures
Windows domain, Determining System and Server Information
serialized procedure execution, Replication Variants
server clustering, Ensuring Availability and Scalability, Creating New Instances of SQL Server
key drawback, Ensuring Availability and Scalability
server logins, Windows Authentication (see )
server objects, Getting Started with SQL Server Management Studio
server options, Working with Server Options, Working with Database Options, Configuring Security for Linked Servers, Configuring Security for Linked Servers
for linked servers, Configuring Security for Linked Servers
for remote servers, Configuring Security for Linked Servers
server roles, Changing Passwords, Changing Passwords, Changing Passwords, Assigning Roles by Login, Revoking Access Rights and Roles by Server Login
assigning roles by login, Changing Passwords
assigning roles to multiple logins, Assigning Roles by Login
configuring, Changing Passwords
revoking access rights and roles, Revoking Access Rights and Roles by Server Login
server settings managing, Configuring Remote Server Connections
serveradmin, Executing Queries and Changing Settings
servers, Managing the Connections Configuration, Managing the Connections Configuration, Deleting a Server Group, Managing Servers, Registering a Connected Server, Registering a New Server in Registered Servers View, Updating Registration for Local Servers, Copying Server Groups and Registration Details from One Computer to Another, Copying Server Groups and Registration Details from One Computer to Another, Connecting to a Server, Connecting to a Server, Removing Catalogs, Tracking Command Execution in SQL Server, Determining System and Server Information, Configuring Remote Server Connections, Linked Servers and Distributed Transactions
(see also )
configuring remote, Configuring Remote Server Connections
connecting, Copying Server Groups and Registration Details from One Computer to Another
deleting, Connecting to a Server
determining information, Determining System and Server Information
disconnecting, Copying Server Groups and Registration Details from One Computer to Another
killing processes, Tracking Command Execution in SQL Server
managing, Deleting a Server Group, Removing Catalogs
moving to a new group, Connecting to a Server
registering connected, Managing Servers
registering new, Registering a Connected Server
registering previously registered SQL Server 2000, Registering a New Server in Registered Servers View
security, Managing the Connections Configuration, Managing the Connections Configuration
updating registration for local, Updating Registration for Local Servers
server-side cursors, Ensuring Connectivity and Data Access
server-to-server administration tasks, Working with Job Categories
Server-Wide Configuration Catalog views, Working with the System Catalog and Catalog Views
Service Broker Catalog views, Working with the System Catalog and Catalog Views
service broker messaging, Accessing SQL Server Configuration Data
Service Broker, Microsoft SQL Server 2005 Administration Overview, Managing SQL Server Component Feature Access, Examining Database Objects
Service Quality Monitoring Reporting, Setting the Startup Service Account
Services utility, Managing the Services Configuration, Managing the Services Configuration, Configuring SQL Server Services
SET commands, Setting Default Connection Options
SET options, Setting Configuration Options, Working with Database Options, Configuring Recovery, Logging, and Disk I/O Error-Checking Options, Using XML Indexes
Shared Memory protocol, Managing the Connections Configuration, Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting, Managing the Network and SQL Native Client Configuration, Managing the Network and SQL Native Client Configuration, Configuring the TCP/IP Network Configuration, Configuring the Native Client Protocol Order, Configuring the Native Client Protocol Order, Configuring the Native Client Protocol Order
enable or disable, Managing the Network and SQL Native Client Configuration, Configuring the Native Client Protocol Order
native client configuration, Configuring the Native Client Protocol Order
preferred local connection, Configuring the TCP/IP Network Configuration, Configuring the Native Client Protocol Order
SID (Security Identifier), Overview of SQL Server 2005 Security
Simple Mail Transfer Protocol (SMTP), Installing a SQL Server Instance, Managing SQL Server Component Feature Access, Managing SQL Server Component Feature Access, Overview of Database Automation and Maintenance
Simple Object Access Protocol (SOAP), Managing SQL Server Component Feature Access, Managing SQL Server Component Feature Access
simple recovery model, Managing Cross-Database Chaining and External Access Options, Initial Backup and Recovery Planning
SMP (symmetric multiprocessors), SQL Server 2005 and Your Hardware, Microsoft SQL Server 2005 Editions, Allocating Memory for Queries, Optimizing CPU Usage
SMTP (Simple Mail Transfer Protocol), Installing a SQL Server Instance, Managing SQL Server Component Feature Access, Managing SQL Server Component Feature Access, Overview of Database Automation and Maintenance
Snapshot Agent, Replication Components, Snapshot and Transactional Publications, Merge Publications, Setting Publication Properties, Creating Subscriptions, Setting Steps to Execute
handles initialization, Creating Subscriptions
setting security in, Setting Publication Properties
SOAP (Simple Object Access Protocol), Managing SQL Server Component Feature Access, Managing SQL Server Component Feature Access
Solutions Explorer view, Using the Graphical Administration Tools
source server, Creating a Warm Standby
special user account, Working with the dbo User
SQL Agent, Accessing SQL Server Configuration Data
SQL Browser service, Managing the Services Configuration
SQL Browser, Microsoft SQL Server 2005 Editions, Installing a SQL Server Instance
SQL Collations, Installing a SQL Server Instance
SQL Mail, Managing SQL Server Component Feature Access, Managing SQL Server Component Feature Access, Working with System Stored Procedures
SQL Mobile, Service Accounts for SQL Server, Using the Graphical Administration Tools
SQL Native Client Configuration, Managing the Surface Security, Access, and Network Configuration, Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting, Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting
managing, Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting
parameters, Managing the Surface Security, Access, and Network Configuration
SQL Native Client Installation, Microsoft SQL Server 2005 Editions, Ensuring Connectivity and Data Access
SQL Native Client, Installing a SQL Server Instance, Configuring the TCP/IP Network Configuration, Server-Based Connections to SQL Server
configuring protocol order, Configuring the TCP/IP Network Configuration
SQL Server 2000, Ensuring Connectivity and Data Access, Configuring and Tuning Microsoft SQL Server, Working with the System Catalog and Catalog Views, Changing Collation and Rebuilding the Master Database, Snapshot and Transactional Publications, Preparing for Log Shipping
collation in, Changing Collation and Rebuilding the Master Database
mapping system tables to SQL Server 2005 system views, Working with the System Catalog and Catalog Views
upgrading log shipping to SQL Server 2005, Preparing for Log Shipping
SQL Server 2005 security overview of, Managing SQL Server 2005 Security
SQL Server 2005 Surface Area Configuration, Managing the Surface Security, Access, and Network Configuration, Getting Started with the Configuration Tools, Connecting to a Remote SQL Server Implementation, Configuring SQL Server Services, Managing the Enterprise
connecting to remote SQL Server, Connecting to a Remote SQL Server Implementation
using, Getting Started with the Configuration Tools
SQL Server 2005, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Administration Overview, Microsoft SQL Server 2005 Administration Overview, SQL Server 2005 and Your Hardware, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions, Services for SQL Server, Services for SQL Server, Service Accounts for SQL Server, Service Accounts for SQL Server, Service Accounts for SQL Server, Using the Graphical Administration Tools, Deploying Microsoft SQL Server 2005, Using SQL Server 2005 for Multidimensional Databases and Data Mining, Using SQL Server 2005 for Multidimensional Databases and Data Mining, Configuring the I/O Subsystem, Ensuring Availability and Scalability, Ensuring Connectivity and Data Access, Ensuring Connectivity and Data Access, Installing a SQL Server Instance, Installing a SQL Server Instance, Installing a SQL Server Instance, Adding Components and Instances, Adding Components and Instances, Uninstalling SQL Server, Managing the Services Configuration, Managing the Connections Configuration, Configuring and Tuning Microsoft SQL Server, Configuring and Tuning Microsoft SQL Server, Configuring and Tuning Microsoft SQL Server, Accessing SQL Server Configuration Data, Working with System Stored Procedures, Techniques for Managing SQL Server Configuration Options, Using SQL Server Management Studio for Queries, Enabling or Preventing Automatic SQL Server Startup, Removing Startup Parameters, Getting Started with SQL Server Management Studio, Troubleshooting Deadlocks and Blocking Connections, Managing the Configuration with SQL Server Management Studio, Determining System and Server Information, Setting Default Language for SQL Server, Allowing and Disallowing Nested Triggers, Flushing Cache with Checkpoints, Copying and Moving Databases, Examining Permissions Granted to Securables, Examining Effective Permissions, Windows Authentication, Profiling and Monitoring Microsoft SQL Server 2005, Adding Publishers and Publisher Groups, Examining the SQL Server Agent Event Logs, Monitoring SQL Server Performance, Creating Trace Logs
accessing configuration data, Configuring and Tuning Microsoft SQL Server
administration overview, Microsoft SQL Server 2005 Administration Overview
authentication, Services for SQL Server, Service Accounts for SQL Server, Using SQL Server Management Studio for Queries, Enabling or Preventing Automatic SQL Server Startup, Getting Started with SQL Server Management Studio, Managing the Configuration with SQL Server Management Studio, Copying and Moving Databases, Examining Effective Permissions
availability and scalability in, Configuring the I/O Subsystem
Catalog views, Configuring and Tuning Microsoft SQL Server, Accessing SQL Server Configuration Data
command-line tools, Using the Graphical Administration Tools
connectivity and data access in, Ensuring Connectivity and Data Access
counters, Monitoring SQL Server Performance, Creating Trace Logs
default instance of, Installing a SQL Server Instance, Installing a SQL Server Instance, Adding Components and Instances
default language, Setting Default Language for SQL Server
deployment planning, Using SQL Server 2005 for Multidimensional Databases and Data Mining
editions, SQL Server 2005 and Your Hardware, Using SQL Server 2005 for Multidimensional Databases and Data Mining
(see also individual edition names)
e-mail within, Working with System Stored Procedures
error messages, Adding Publishers and Publisher Groups
functions for examining permissions, Examining Permissions Granted to Securables
graphical administration tools in, Service Accounts for SQL Server
hardware requirements, Microsoft SQL Server 2005 Administration Overview
installation process, Microsoft SQL Server 2005 Editions
integration roles, Deploying Microsoft SQL Server 2005
logins, Windows Authentication
managing component feature access, Managing the Connections Configuration
managing connections configuration, Managing the Services Configuration
memory requirements, Microsoft SQL Server 2005 Administration Overview
monitoring performance and activity, Profiling and Monitoring Microsoft SQL Server 2005, Examining the SQL Server Agent Event Logs
named instance, Installing a SQL Server Instance, Adding Components and Instances
new instances of, Ensuring Connectivity and Data Access
recovering from bad configuration, Flushing Cache with Checkpoints
replication, Ensuring Availability and Scalability
security, Service Accounts for SQL Server, Determining System and Server Information
service accounts for, Services for SQL Server
services for, Microsoft SQL Server 2005 Editions
startup parameters, Removing Startup Parameters
techniques for managing configuration options, Techniques for Managing SQL Server Configuration Options
tracking command execution in, Troubleshooting Deadlocks and Blocking Connections
uninstalling, Uninstalling SQL Server
workstation installation, Microsoft SQL Server 2005 Editions
windows and, Microsoft SQL Server 2005 Editions
year 2000 support, Allowing and Disallowing Nested Triggers
SQL Server Agent, Microsoft SQL Server 2005 Editions, Other Command-Line Tools, Installing a SQL Server Instance, Managing the Services Configuration, Working with System Stored Procedures, Getting Started with SQL Server Management Studio, Connecting to a Server, Using Scheduled Jobs to Populate Catalogs for a Specific Table or View, Working with the NETWORK SERVICE and SYSTEM Logins, Setting Up a New Distributor, Enabling and Updating Publishers, Monitoring Tools and Resources, Examining the SQL Server Event Logs, Overview of Database Automation and Maintenance, Overview of Database Automation and Maintenance, Using Database Mail, Viewing or Changing Database Mail System Parameters, Viewing or Changing Database Mail System Parameters, Setting the SQL Server Agent Mail Profile, Setting the SQL Server Agent Mail Profile, Handling Notification Messages
alerts, jobs, and operators, Overview of Database Automation and Maintenance, Viewing or Changing Database Mail System Parameters, Handling Notification Messages
database mail, Using Database Mail
event logs, Examining the SQL Server Event Logs
logs, Monitoring Tools and Resources
mail profile, Setting the SQL Server Agent Mail Profile
restarting services automatically, Setting the SQL Server Agent Mail Profile
runs scheduled tasks, Using Scheduled Jobs to Populate Catalogs for a Specific Table or View
starting, stopping, and configuring, Connecting to a Server
stored procedures, Working with System Stored Procedures
SQL Server Agent proxy account, Managing SQL Server Component Feature Access
SQL Server Agent services, Creating New Instances of SQL Server, Installing a SQL Server Instance, Installing a SQL Server Instance, Checking System and Sample Databases, Accessing Alerts, Operators, and Jobs
configuring, Accessing Alerts, Operators, and Jobs
SQL Server Books Online, Microsoft SQL Server 2005 Editions, Adding Components and Instances, Database Corruption and Problem Resolution
SQL Server Configuration Manager, Using the Graphical Administration Tools, Managing the Surface Security, Access, and Network Configuration, Managing the Services Configuration, Configuring SQL Server Services, Managing the Enterprise, Starting, Stopping, and Configuring the Microsoft Distributed Transaction Coordinator
SQL Server Database Engine, Deploying Microsoft SQL Server 2005, Uninstalling SQL Server, Accessing Alerts, Operators, and Jobs
uninstalling, Uninstalling SQL Server
SQL Server Database Services, Microsoft SQL Server 2005 Administration Overview
SQL Server for Windows CE, Snapshot and Transactional Publications
SQL Server groups, Managing SQL Server Groups, Managing SQL Server Groups, Managing SQL Server Groups, Managing SQL Server Groups, Creating a Server Group, Deleting a Server Group, Deleting a Server Group, Deleting a Server Group, Updating Registration for Local Servers
adding, Deleting a Server Group
copying, Updating Registration for Local Servers
creating, Managing SQL Server Groups
deleting, Creating a Server Group
editing and moving, Deleting a Server Group
managing, Managing SQL Server Groups
subgroups, Managing SQL Server Groups
top-level, Managing SQL Server Groups
SQL Server Import and Export Wizard, Using the Graphical Administration Tools, Importing, Exporting, and Transforming Data, Integration Services Tools, Integration Services and Data Providers, Integration Services Packages, Building a Query
creating packages with, Integration Services Packages
moving data between systems, Integration Services and Data Providers
sets default mapping, Building a Query
SQL Server installation folder, Services for SQL Server
SQL Server Installation process, Microsoft SQL Server 2005 Editions, Working with Database Options
SQL Server Integration Services (SSIS), Other Command-Line Tools, Deploying Microsoft SQL Server 2005, Installing a SQL Server Instance, Managing the Services Configuration, Importing, Exporting, and Transforming Data, Working with Integration Services, Integration Services Tools, Integration Services and Data Providers
data providers and, Integration Services Tools
packages, Integration Services and Data Providers
tools, Working with Integration Services
SQL Server logs, Monitoring Tools and Resources
SQL Server Management Studio, Service Accounts for SQL Server, Service Accounts for SQL Server, Using the Graphical Administration Tools, Deploying Microsoft SQL Server 2005, Managing SQL Server Component Feature Access, Configuring and Tuning Microsoft SQL Server, Working with Server Options, Managing Database Compatibility, Managing Database Compatibility, Managing the Enterprise, Enabling or Preventing Automatic SQL Server Startup, Managing the SQL Server Command-Line Executable File, Managing the SQL Server Command-Line Executable File, Managing the SQL Server Command-Line Executable File, Deleting a Server Group, Configuring SQL Server with SQL Server Management Studio, Configuring SQL Server with SQL Server Management Studio, Database Files and Logs, Creating Databases, Altering Databases and Their Options, Viewing, Changing, and Overriding Database Options, Viewing and Editing Existing Logins, Managing Database Permissions, Working with Schemas, Setting Unique Constraints, Working with Integration Services, Building a Query, Deleting Distribution Databases, Creating a Backup Device
backups in, Creating a Backup Device
creating databases in, Creating Databases
creating logins in, Viewing and Editing Existing Logins
creating schemas in, Working with Schemas
creating unique indexes in, Setting Unique Constraints
database administration basics in, Database Files and Logs
Disable Publishing And Distribution Wizard, Deleting Distribution Databases
getting started with, Managing the SQL Server Command-Line Executable File
grant, revoke, or deny permission, Managing Database Permissions
managing configuration, Configuring SQL Server with SQL Server Management Studio
managing file size, Viewing, Changing, and Overriding Database Options
managing servers, Deleting a Server Group
Object Explorer view, Enabling or Preventing Automatic SQL Server Startup
server options in, Working with Server Options
queries, Managing Database Compatibility, Building a Query
replaces Enterprise Manager, Configuring SQL Server with SQL Server Management Studio
setting database options in, Altering Databases and Their Options
using, Managing the SQL Server Command-Line Executable File
views in, Service Accounts for SQL Server
(see also individual view names.)
SQL Server Profiler Stored Procedures, Working with System Stored Procedures
SQL Server Profiler, Using the Graphical Administration Tools, Other Command-Line Tools, Using XML Indexes, Monitoring Tools and Resources, Configuring Alerts for Performance Counters, Configuring Alerts for Performance Counters, Using Profiler
determine types of queries being run, Using XML Indexes
solving performance problems with, Configuring Alerts for Performance Counters
templates, Using Profiler
SQL Server registry, Ensuring Connectivity and Data Access
SQL Server Service Broker, Managing SQL Server Component Feature Access
SQL Server service, Services for SQL Server, Installing a SQL Server Instance, Moving Databases
SQL Server services, Managing the Services Configuration, Managing the Services Configuration, Configuring SQL Server Services
configuring, Configuring SQL Server Services
SQL Server Setup, Ensuring Connectivity and Data Access
SQL Server startup, Managing the Enterprise, Managing the Enterprise, Managing the Enterprise
enabling or preventing automatic, Managing the Enterprise
managing, Managing the Enterprise
SQL standard, Configuring Cursor Options
SQL-92, Controlling ANSI Compliance at the Database Level, Using Distributed Queries
SqlClient.NET Data Provider, Ensuring Connectivity and Data Access, Ensuring Connectivity and Data Access
SQLCMD, Using the Graphical Administration Tools, Ensuring Connectivity and Data Access
SQLServr.exe, Configuring and Tuning Microsoft SQL Server, Setting Database Engine Startup Parameters, Managing the SQL Server Command-Line Executable File
SQLXML, Integration Services Tools, Stage 1: Source and Destination Configuration
SQM reporting, Setting the Startup Service Account
SSIS, Other Command-Line Tools (see )
Standard Edition, SQL Server 2005 and Your Hardware, Microsoft SQL Server 2005 Editions, Microsoft SQL Server 2005 Editions
standard procedure execution, Replication Variants
standby servers, Initial Backup and Recovery Planning, Initial Backup and Recovery Planning, Initial Backup and Recovery Planning, Initial Backup and Recovery Planning, Restoring a Database to a Different Location, Restoring a Database to a Different Location, Restoring a Database to a Different Location, Creating a Cold Standby, Creating a Cold Standby
cold, Initial Backup and Recovery Planning, Restoring a Database to a Different Location, Creating a Cold Standby
creating, Restoring a Database to a Different Location
hot, Initial Backup and Recovery Planning
warm, Initial Backup and Recovery Planning, Restoring a Database to a Different Location, Creating a Cold Standby
startup parameters, Managing the Services Configuration, Setting Database Engine Startup Parameters
setting database engine, Setting Database Engine Startup Parameters
startup service account setting, Setting the Startup Service Account
statement permissions, Working with the dbo User, Statement Permissions
statistics, updating, Attaching and Detaching Databases, Creating Indexes
in indexes, Creating Indexes
storage area networks (SANs), Configuring the I/O Subsystem
stored procedures, Configuring and Tuning Microsoft SQL Server, Working with System Stored Procedures, Managing Database Compatibility, Starting, Stopping, and Configuring SQL Server Agent, Configuring Remote Server Connections, Checking System and Sample Databases, Examining Permissions Granted to Securables, Replication Variants, Reasons to Monitor SQL Server
(see also individual procedure names)
as articles in snapshot publication, Replication Variants
configuring SQL Server with, Managing Database Compatibility
handled as distributed transactions, Configuring Remote Server Connections
key system stored procedures by type, Working with System Stored Procedures
sp_who, Reasons to Monitor SQL Server
subscription databases, Planning for Mirroring and Mirrored Database Backups, Planning for Backups of Replicated Databases
subscriptions, Creating a Script for a Publication, Creating a Script for a Publication, Creating a Script for a Publication, Subscription Essentials, Subscription Essentials, Subscription Essentials, Creating Subscriptions, Creating Subscriptions, Creating Subscriptions, Updating, Maintaining, and Deleting Subscriptions, Reinitializing Subscriptions
anonymous subscription, Subscription Essentials
creating, Subscription Essentials
properties, Creating Subscriptions
pull, Creating a Script for a Publication, Subscription Essentials
push, Creating a Script for a Publication
reinitializing, Reinitializing Subscriptions
updating, and deleting, Creating Subscriptions, Creating Subscriptions
validating, Updating, Maintaining, and Deleting Subscriptions
supplemental logging, Configuring Recovery, Logging, and Disk I/O Error-Checking Options
surface area access, Managing SQL Server Component Feature Access
symmetric multiprocessors (SMP), SQL Server 2005 and Your Hardware, Microsoft SQL Server 2005 Editions, Allocating Memory for Queries, Optimizing CPU Usage
synonyms, Working with Schemas
sysadmin fixed server role, Ensuring Connectivity and Data Access, Executing Queries and Changing Settings, Core Database Administration, Managing Cross-Database Chaining and External Access Options, Copying and Moving Databases, Using the BULK INSERT Command
System Administrators, Special Purpose Logins and Users
system catalog, Configuring and Tuning Microsoft SQL Server, Accessing SQL Server Configuration Data
System Catalog Queries, Configuring and Tuning Microsoft SQL Server
system databases, Database Files and Logs, Viewing Database Information Using T-SQL, Viewing Database Information Using T-SQL, Renaming a Database, Attaching and Detaching Databases
checking, Viewing Database Information Using T-SQL
cannot drop or detach, Renaming a Database, Attaching and Detaching Databases
summary of, Viewing Database Information Using T-SQL
system information determining, Determining System and Server Information
system stored procedures and functions, Configuring and Tuning Microsoft SQL Server, Working with System Stored Procedures, Setting Default Language for SQL Server
updating systems table with, Setting Default Language for SQL Server
working with, Working with System Stored Procedures
system updates allowing and disallowing, Setting Default Language for SQL Server

T

table join, Getting Started with Tables
Tables catalog view, Accessing SQL Server Configuration Data
tables, Checking System and Sample Databases, Getting Started with Tables, Understanding Data Pages, Understanding Table Partitions, Understanding Table Partitions, Understanding Table Partitions, Modifying Existing Tables, Modifying Existing Tables, Viewing Table Row and Size Information, Displaying Table Properties and Permissions, Displaying Table Properties and Permissions, Copying Tables, Copying Tables, Copying Tables, Adding and Removing Columns in a Table, Adding and Removing Columns in a Table, Copying Users, Tables, Views, and Other Objects from One Database to Another
adding and removing columns, Copying Tables
copying, Displaying Table Properties and Permissions, Copying Users, Tables, Views, and Other Objects from One Database to Another
creating, Understanding Table Partitions
current values in, Displaying Table Properties and Permissions
deleting, Copying Tables
essentials, Getting Started with Tables
modifying, Modifying Existing Tables
naming, Understanding Table Partitions
partitions, Understanding Data Pages
properties and permissions, Viewing Table Row and Size Information
renaming, Copying Tables
scripting, Adding and Removing Columns in a Table
temporary, Understanding Table Partitions
values, Adding and Removing Columns in a Table
viewing row and size information, Modifying Existing Tables
tape drives, Planning for Backups of Very Large Databases
tape rotation technique, Adding to an Existing Backup Set
target system, Requirements for Replaying Traces
TCP/IP protocol, Managing the Connections Configuration, Managing the Connections Configuration, Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting, Configuring the Named Pipes Network Configuration, Configuring the Native Client Protocol Order
configuring, Configuring the Named Pipes Network Configuration
native client configuration, Configuring the Native Client Protocol Order
Telnet, Managing Services from the Command Line, Managing the SQL Server Command-Line Executable File, Flushing Cache with Checkpoints
tempdb database, Viewing Database Information Using T-SQL, Moving Databases, Moving Databases, Working with the NETWORK SERVICE and SYSTEM Logins, Understanding Table Partitions, Replication Components, Initial Backup and Recovery Planning
improving performance of, Moving Databases
moving and resizing, Moving Databases
temporary tables created in, Understanding Table Partitions
use simple recovery model, Initial Backup and Recovery Planning
Template Explorer view, Using the Graphical Administration Tools
templates, Using the Graphical Administration Tools
temporary tables, Understanding Table Partitions
Terminal Server session, Managing Services from the Command Line
Terminal Server, Managing the SQL Server Command-Line Executable File, Flushing Cache with Checkpoints
text file drive, Integration Services and Data Providers
threading, configuring, Setting Parallel Processing
threads, Setting Parallel Processing, Setting Parallel Processing, Configuring Threading, Priority, and Fibers
match to user connections, Setting Parallel Processing
SQL Server, Configuring Threading, Priority, and Fibers
torn pages, Configuring Recovery, Logging, and Disk I/O Error-Checking Options
Total Server Memory counter, Working with Dynamically Configured Memory
trace files, Using Profiler
Trace flags, Managing Services from the Command Line
trace tables, Using Profiler
traces, Creating Trace Logs, Using Profiler, Creating New Traces, Creating New Traces, Replaying a Trace, Requirements for Replaying Traces
analyzing, Requirements for Replaying Traces
creating new, Using Profiler
logs, Creating Trace Logs
replaying, Replaying a Trace
saving, Creating New Traces
transaction logs, Configuring the I/O Subsystem, Ensuring Availability and Scalability, Core Database Administration, Core Database Administration, Creating Databases in SQL Server Management Studio, Configuring Recovery, Logging, and Disk I/O Error-Checking Options, Compressing and Shrinking a Database Manually, Attaching a Database with Multiple Files, Creating Secondary Data and Log Files, Adding to an Existing Backup Set, Performing Transaction Log Backups, Restoring a Database from a Normal Backup, Adding Log Shipping Secondaries, Using Mirroring and Log Shipping
asynchronous vs. synchronous, Ensuring Availability and Scalability
backups, Adding to an Existing Backup Set, Performing Transaction Log Backups
changing backup interval, Adding Log Shipping Secondaries
configuring files, Creating Databases in SQL Server Management Studio
not needed in new database, Attaching a Database with Multiple Files
preventing errors, Creating Secondary Data and Log Files
rolling back the transaction, Core Database Administration
transaction manager, Using Distributed Transactions
Transact-SQL (T-SQL), SQLCMD, Using SQL Server Integration Services, Managing SQL Server Component Feature Access, Configuring and Tuning Microsoft SQL Server, Working with System Stored Procedures, Techniques for Managing SQL Server Configuration Options, Working with Full-Text Search, Allowing and Disallowing Nested Triggers, Creating Databases Using T-SQL, Expanding Databases and Logs Manually, Viewing and Editing Existing Logins, Creating Logins, Creating Logins, Removing Role Memberships for Database Users, Managing Database Permissions, Creating Schemas, Setting Unique Constraints, Using Striped Backups with Multiple Devices, Creating a Warm Standby
adding files using, Expanding Databases and Logs Manually
backing up databases, Using Striped Backups with Multiple Devices
creating databases, Creating Databases Using T-SQL
creating logins, Creating Logins
creating schemas, Creating Schemas
creating unique indexes, Setting Unique Constraints
editing logins using, Creating Logins
grant, revoke, or deny permissions, Managing Database Permissions
managing access and roles, Removing Role Memberships for Database Users
restore commands, Creating a Warm Standby
setting per-connection query cost limit, Allowing and Disallowing Nested Triggers
used to backup and restore catalogs, Working with Full-Text Search
viewing login information, Viewing and Editing Existing Logins
Transact-SQL commands, Setting Steps to Execute
transformation, Building a Query
tree structure, Managing Views
triggers, Checking System and Sample Databases, Using Views, Replication Variants
troubleshooting, Ensuring Connectivity and Data Access, Troubleshooting Deadlocks and Blocking Connections, Flushing Cache with Checkpoints, Setting Online, Offline, or Emergency Mode, Viewing and Editing Existing Logins, Creating Trace Logs, Creating Trace Logs, Creating New Traces, Backing Up Full-Text Search Catalogs, Database Corruption and Problem Resolution, Performing the Initial Database Mail Configuration
configuration problems, Flushing Cache with Checkpoints
connection issues, Viewing and Editing Existing Logins
Database Mail, Performing the Initial Database Mail Configuration
database problems, Setting Online, Offline, or Emergency Mode, Backing Up Full-Text Search Catalogs, Database Corruption and Problem Resolution
deadlocks, Troubleshooting Deadlocks and Blocking Connections
logging performance, Creating Trace Logs
T-SQL, SQLCMD (see )

U

UDM (Unified Dimension Model), Using SQL Server Integration Services
Unicode characters, Importing and Exporting Flat Files
Unified Dimension Model (UDM), Using SQL Server Integration Services
uninterruptible power supply (UPS), SQL Server 2005 and Your Hardware
updating statistics, Attaching and Detaching Databases (see )
UPS (uninterruptible power supply), SQL Server 2005 and Your Hardware
USE statement, Managing Database Compatibility
user access, Configuring Cursor Options
user accounts, Installing a SQL Server Instance, Examining Effective Permissions, Examining Effective Permissions, Examining Effective Permissions
for authentication, Examining Effective Permissions
Local vs. Domain, Installing a SQL Server Instance, Examining Effective Permissions
user connections, SQL Server 2005 and Your Hardware, Microsoft SQL Server 2005 Editions, Configuring Threading, Priority, and Fibers, Configuring Threading, Priority, and Fibers, Configuring User and Remote Connections, Setting Maximum User Connections
configuring, Configuring Threading, Priority, and Fibers
default, Setting Maximum User Connections
maximum, Configuring User and Remote Connections
memory required for, SQL Server 2005 and Your Hardware
remote, Configuring Threading, Priority, and Fibers
user mode, Setting Parallel Processing
user privileges, Enabling AWE Memory Support
user-defined application roles, Server Roles
user-defined data types, Checking System and Sample Databases, Using Fixed-Length, Variable-Length, and Max-Length Fields, Using Fixed-Length, Variable-Length, and Max-Length Fields, Creating User-Defined Data Types, Understanding Indexes, Using Rules
CLR, Understanding Indexes
creating, Using Fixed-Length, Variable-Length, and Max-Length Fields
managing, Creating User-Defined Data Types
rules bound to, Using Rules
user-defined functions, Checking System and Sample Databases
user-defined roles, Removing Role Memberships for Database Users
user-defined standard roles, Server Roles, Removing Role Memberships for Database Users
users, Windows Authentication

V

values, Allowing and Disallowing Nulls
variable-length fields, Using Native Data Types
VIA (Virtual Interface Architecture), Managing the Connections Configuration, Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting
views, Checking System and Sample Databases, Using Identities and Globally Unique Identifiers, Using Views, Using Views, Working with Views, Creating Views, Modifying Views, Modifying Views, Copying Users, Tables, Views, and Other Objects from One Database to Another
as database object, Checking System and Sample Databases
copying, Copying Users, Tables, Views, and Other Objects from One Database to Another
creating, Working with Views
indexed, Using Views
managing, Modifying Views
modifying, Creating Views
partitioned, Using Views
updatable, Modifying Views
Virtual Interface Architecture (VIA), Managing the Connections Configuration, Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting
Visual Basic, Integration Services and Data Providers

W

warm standby servers, Initial Backup and Recovery Planning, Restoring a Database to a Different Location, Creating a Cold Standby
warning, Examining the Application Log
Web Assistant, Managing SQL Server Component Feature Access
Web services, Accessing SQL Server Configuration Data
wildcard, Examining Built-in Permissions
Windows 2000 Advanced Server, Microsoft SQL Server 2005 Editions
Windows 2000 Datacenter Server, Microsoft SQL Server 2005 Editions
Windows 2000 Scripting Guide, BCP Scripts
Windows 2000, Managing the Network and SQL Native Client Configuration
Windows 95, Determining System and Server Information
Windows 98, Managing the Network and SQL Native Client Configuration, Configuring the TCP/IP Native Client Configuration, Determining System and Server Information
Windows authentication, Installing a SQL Server Instance, Using SQL Server Management Studio for Queries, Enabling or Preventing Automatic SQL Server Startup, Getting Started with SQL Server Management Studio, Managing the Configuration with SQL Server Management Studio, Determining System and Server Information, Copying and Moving Databases, Examining Effective Permissions
setting mode, Determining System and Server Information
Windows Command-Line Administrator’s Pocket Consultant, BCP Scripts
Windows group, Working with Schemas
Windows Installer 3.0, Creating New Instances of SQL Server
Windows Messenger, Microsoft SQL Server 2005 Administration Overview
Windows NT, Managing the Network and SQL Native Client Configuration, Configuring the TCP/IP Native Client Configuration
Windows Performance Monitor, Managing the Enterprise, Monitoring Tools and Resources, Examining the SQL Server Agent Event Logs, Choosing Counters to Monitor, Creating Counter Logs, Creating Trace Logs, Creating Trace Logs, Configuring Alerts for Performance Counters
configuring alerts, Creating Trace Logs
creating and managing logs, Choosing Counters to Monitor
Windows Server 2003, Creating New Instances of SQL Server, Managing the Network and SQL Native Client Configuration, Managing Services from the Command Line, Managing the SQL Server Command-Line Executable File, Using Fixed Memory
enabling AWE memory support, Using Fixed Memory
Service Pack 1, Creating New Instances of SQL Server
Windows XP Professional, Creating New Instances of SQL Server, Managing the Network and SQL Native Client Configuration
Service Pack 2, Creating New Instances of SQL Server
witness server, Ensuring Availability and Scalability, Initial Backup and Recovery Planning, Configuring Mirroring
Workgroup Edition, SQL Server 2005 and Your Hardware, Microsoft SQL Server 2005 Editions
Workstation Components, Microsoft SQL Server 2005 Editions

X

XML (Extensible Markup Language), Using SQL Server Integration Services, Managing SQL Server Component Feature Access, Techniques for Managing SQL Server Configuration Options
stored procedures, Techniques for Managing SQL Server Configuration Options
XML data type, Working with Full-Text Search
XML index, Understanding Indexes, Understanding Indexes
XML Schemas (XML Type System) Catalog views, Working with the System Catalog and Catalog Views

Y

year 2000 support, Allowing and Disallowing Nested Triggers
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset