After completing SQL Server 7 Admin: Configuring the user should be able to:

	Register a server with a SQL Server network
	Configure Microsoft SQL Server 7 including installing and configuring SQL Mail and configuring the default ANSI settings
	Install and configure the Full-Text Search service including enabling Full-Text Search on specific columns and tables and creating and managing indexes to support Full-Text Search

Using the Register Server Wizard

	Registering servers
	Registration Wizard: step by step
	Registering without the wizard

Configuring the Server

	Changing the sa password
	Managing the server configuration

Configuring SQL Mail and ANSI Settings

	Using SQL Server Mail
	Configuring SQL Mail
	Configuring default ANSI settings

Installing the Full-Text Search Service

	Using the Full-Text Search Service (FTS)
	Installing the Full-Text Search Service
	Configuring Full-Text Service properties

Configuring the Full-Text Search Service

	Enabling Full-Text Search Service
	Using the Full-Text Indexing Wizard
	Confirming the process

This course has the following features:

	Exercises that allow users to practice in SQL Server 7.0
	A file containing the text of the exercises
	Simulations that allow users to practice course skills even if they don't have access to SQL Server 7.0
	A glossary
	A Skill Assessment

	Courses on Relational Database Management Systems or equivalent experience
	Courses on Windows NT administration or equivalent experience
	Courses on Database Concepts or equivalent experience
	Courses on SQL or equivalent experience
	SQL Server 7 Admin: Security Strategy (LA7C01)
	SQL Server 7 Admin: System Requirements (LA7C02)
	SQL Server 7 Admin: Migration Planning (LA7C03)
	SQL Server 7 Admin: Replication Plans (LA7C04)
	SQL Server 7 Admin: Installing the Server (LA7C05)
	SQL Server 7 Admin: Other Installations (LA7C06)

Microsoft® is a registered trademark of Microsoft Corporation.