Mark Horninger Technical Editor Valentine Boairkine and Herleson Pontes Lead Authors
Dinesh Asanka Denny Cherry Justin Langford Steve Long 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 warrant the results to be obtainedfrom 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 out from the Work or itscontents. 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 Skill Enhancement®,” “Ask the AuthorUPDATE®,” 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 BY Syngress Publishing, Inc.Elsevier, Inc. 30 Corporate Drive Burlington, MA 01803
The Real MCTS SQL Server 2008 Exam 70-433 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 database or retrieval system, withoutthe 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 1234567890 ISBN 13: 978-1-59749-421-2 Publisher: Laura Colantoni Acquisitions Editor: Rachel Roumeliotis Technical Editor: Mark Horninger Developmental Editor:Gary Byrne Indexer: SPi Project Manager: Heather Tighe Page Layout and Art: SPi Copy Editors: Adrienne Rebello, Leslie Crenna, Betty Pessagno Cover Designer: Michael Kavish
For information on rights, translations, and bulk sales, contact Matt Pedersen, Director of Corporate Sales, Elsevier; email email@example.com. Library of Congress Cataloging-in-Publication Data Application submittedTechnical Editor
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. He develops 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 Elsevier Inc. Mark has also served as an adjunct professor at Kaplan University teaching Web design. Markhas 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.
Valentine Boiarkine (MCSE, MCDBA, MCSD, MCT) is a founding partner at Blade Ltd., a software...