Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and the publisher was aware of a trademark claim, the designations have been printed with initial capital letters or in all capitals.

The .NET logo is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries and is used under license from Microsoft.

The authors and publisher have taken care in the preparation of this book, but make no expressed or implied warranty of any kind and assume no responsibility for errors or omissions. No liability is assumed for incidental or consequential damages in connection with or arising out of the use of the information or programs contained herein.

The publisher offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales, which may include electronic versions and/or custom covers and content particular to your business, training goals, marketing focus, and branding interests. For more information, please contact:

     U.S. Corporate and Government Sales
     (800) 382-3419
     [email protected]

For sales outside the United States, please contact:

     International Sales
     [email protected]

Visit us on the Web: www.awprofessional.com

Library of Congress Cataloging-in-Publication Data
Beauchemin, Bob.
     A developer’s guide to SQL server 2005 / Bob Beauchemin, Dan Sullivan.
       p. cm.
     Includes bibliographical references and index.
     ISBN 0-321-38218-8 (pbk. : alk. paper)
    1. SQL server. 2. Client/server computing. 3. Relational databases. I.
Sullivan, Dan. II. Title.
     QA76.9.C55B425 2006
     005.2’768—dc22
                                                              2006003470

Copyright © 2006 Pearson Education, Inc.

All rights reserved. Printed in the United States of America. This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permissions, write to:

     Pearson Education, Inc.
     Rights and Contracts Department
     75 Arlington Street, Suite 300
     Boston, MA 02116
     Fax: (617) 848-7047

Text printed in the United States at Courier in Stoughton, Massachusetts.

First printing, May 2006