Mark Horninger Technical Editor Valentine Boiarkine, Denny Cherry, and Steve Long Lead Authors
Dinesh Asanka Christian Bolton Justin Langford Bret Stateham Sylvia Vargas
Elsevier, Inc., the author(s), and any person or firm involved in the writing, editing, or production (collectively “Makers”) of this book (“the Work”) do not guarantee or warrantthe results to be obtained from the Work. There is no guarantee of any kind, expressed or implied, regarding the Work or its contents. The Work is sold AS IS and WITHOUT WARRANTY. You may have other legal rights, which vary from state to state. In no event will Makers be liable to you for damages, including any loss of profits, lost savings, or other incidental or consequential damages arising outfrom the Work or its contents. Because some states do not allow the exclusion or limitation of liability for consequential or incidental damages, the above limitation may not apply to you. You should always use reasonable care, including backup and other appropriate precautions, when working with computers, networks, data, and files. Syngress Media®, Syngress®, “Career Advancement Through SkillEnhancement®,” “Ask the Author UPDATE®,” and “Hack Proofing®,” are registered trademarks of Elsevier, Inc. “Syngress: The Definition of a Serious Security Library”™, “Mission Critical™,” and “The Only Way to Stop a Hacker is to Think Like One™” are trademarks of Elsevier, Inc. Brands and product names mentioned in this book are trademarks or service marks of their respective companies. PUBLISHED BYSyngress Publishing, Inc. Elsevier, Inc. 30 Corporate Drive Burlington, MA 01803
The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit
Copyright © 2009 by Elsevier, Inc. 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 databaseor 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. Printed in the United States of America 1 2 3 4 5 6 7 8 9 0 ISBN 13: 978-1-59749-420-5 Publisher: Laura Colantoni Acquisitions Editor: Rachel Roumeliotis Technical Editor:Mark Horninger Developmental Editor: Gary Byrne Indexer: SPI Project Manager: Andre Cuello Page Layout and Art: SPI Copy Editors: Leslie Crenna, Betty Pasagno, Adrienne Rebello, Christina Solstad, and Jessica Springer Cover Designer: Michael Kavish
For information on rights, translations, and bulk sales, contact Matt Pedersen, Commercial Sales Director and Rights, at Syngress Publishing; email@example.com. Library of Congress Cataloging-in-Publication Data Application submitted
Mark Horninger (A+, Net+, Security+, MCSE+I, MCSD, MCAD,MCDBA, MCTS, MCITP, MCPD) is manager of database operations at Internet Pipeline, Inc. He is also the founder of Haverford Consultants, Inc. (www.haverfordconsultants.com/), located in the suburbs of Philadelphia, PA. Hedevelops custom applications and system engineering solutions, specializing primarily in Microsoft .NET technology and Microsoft SQL Server. He is a contributing author to Securing SQL 2005, Configuring and Troubleshooting Windows XP Professional MCSE Windows 2000 Professional Study Guide and Designing SQL Server 2000 Databases for .NET Enterprise Servers published by Syngress, an imprint of ElsevierInc. Mark has also served as an adjunct professor at Kaplan University teaching Web design. Mark has over 20 years of computer consulting experience and has passed 50+ Microsoft Certification Exams. He lives with his wife, Debbie, and son, Robby, in the Philadelphia area. Mark would like to thank his wife, Debbie, for her infinite patience, love, and support during this project.