SQL Server 2000 for Experienced DBAs

Brian Knight

McGraw-Hill/Osborne

McGraw-Hill/Osborne
2600 Tenth Street
Berkeley, California 94710
U.S.A.

To arrange bulk purchase discounts for sales promotions, premiums, or fund-raisers, please contact McGraw-Hill/Osborne at the above address. For information on translations or book distributors outside the U.S.A., please see the International Contact Information page immediately following the index of this book.

SQL Server^™ 2000 for Experienced DBAs

Copyright © 2003 by The McGraw-Hill Companies. All rights reserved. Printed in the United States
of America. Except as permitted under the Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written permission of the publisher, with the exception that the program listings may be entered, stored, and executed in a computer system, but they may not be reproduced for publication.

1234567890 CUS CUS 019876543

ISBN 0-07-222788-5

Publisher: Brandon A. Nordin

Vice President & Associate Publisher: Scott Rogers

Acquisitions Editor: Lisa McClain

Project Editors: Patty Mon, Janet Walden

Acquisitions Coordinator: Athena Honore

Technical Editor: Steve Jones

Copy Editor: Lunaea Weatherstone

Proofreader: Pat Mannion

Indexer: Valerie Robbins

Computer Designers: Lucie Ericksen, John Patrus

Illustrators: Melinda Moore Lytle, Michael Mueller, Lyssa Wald

Series Designers: Peter F. Hancik, Roberta Steele

Cover Series Designer: Pattie Lee

This book was composed with Corel VENTURA^™ Publisher.

Information has been obtained by McGraw-Hill/Osborne from sources believed to be reliable. However, because of the possibility of human or mechanical error by our sources, McGraw-Hill/Osborne, or others, McGraw-Hill/Osborne does not guarantee the accuracy, adequacy, or completeness of any information and is not responsible for any errors or omissions or the results obtained from use of such information.

This book is dedicated to my baby son Colton, who has a smile that makes me remember my priorities. I watched him grow from a crawler to a walker during the writing of this book.

Acknowledgments

Foremost, I must thank my ever-patient wife Jennifer, who took care of all the dull things that I neglected during the writing of this book. She and our one-year-old son Colton are the most precious things in my life. Thanks to my boss David Page, for having patience with an employee who crawled into work toward the end of this book project. Thanks also to my wonderful tech editor Steve Jones. And, what would an acknowledgment be without thanking Mountain Dew for providing enough caffeine at night to get through the writing of this book.

About the Author

Brian Knight, MCSE, MCDBA, is on the board of directors for the Professional Association for SQL Server (PASS) and runs the local SQL Server users group in Jacksonville, Florida. Brian is a contributing columnist for SQL Magazine and also maintains a weekly column for the database website SQLServerCentral.com. He is the author of Admin911: SQL Server 2000 (McGraw-Hill/Osborne). Brian also is a SQL Server database manager at Fidelity Information Systems in Jacksonville, FL.