Microsoft SQL Server 7.0 System Administration Training Kit

PUBLISHED BY Microsoft Press A Division of Microsoft Corporation One Microsoft Way Redmond, Washington 98052-6399

Copyright © 1999 by Microsoft Corporation

All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

Library of Congress Cataloging-in-Publication Data Microsoft SQL Server 7.0 System Administration Training Kit / Microsoft Corporation. p. cm. ISBN 1-57231-827-9 1. SQL server. 2. Client/server computing. I. Microsoft Corporation QA76.9.C55M534 1999 005.75'85--dc21 99-13556 CIP

Printed and bound in the United States of America.

1 2 3 4 5 6 7 8 9   WCWC   4 3 2 1 0 9

Distributed in Canada by ITP Nelson, a division of Thomson Canada Limited.

A CIP catalogue record for this book is available from the British Library.

Microsoft Press books are available through booksellers and distributors worldwide. For further information about international editions, contact your local Microsoft Corporation office or contact Microsoft Press International directly at fax (425) 936-7329. Visit our Web site at mspress.microsoft.com.

ActiveX, BackOffice, JScript, Microsoft, Microsoft Press, MS-DOS, Outlook, PivotTable, Visual Basic, Visual FoxPro, Windows, and Windows NT are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other product and company names mentioned herein may be the trademarks of their respective owners.

The example companies, organizations, products, people, and events depicted herein are fictitious. No association with any real company, organization, product, person, or event is intended or should be inferred.

For The Information Management Group Writers: Sean Nolan, Tom Huguelet Graphic Artist: Jesse Wolfe Technical Contributors: Jodi Allen, Dan Christie

For Microsoft (Original Instructor-Led Course Content) Dan Basica, Homer Christensen, Wendy Cleary, Margo Crandall, Karl Dehmer, Stacey Dickinson, Xandria Eykel, Cheryl Hoople, Marilyn McGill, Lori Oviatt, Carl Rabeler, Adam Shapiro

For Microsoft Press Program Manager: Jeff Madden Project Editor: Michael Bolinger Technical Editor: Nick Cavalancia

Part No. 097-0002093