Microsoft SQL Server 2005-The Complete Reference

Jeffrey Shapiro

New York Chicago San FranciscoLisbon London Madrid Mexico CityMilan New Delhi San JuanSeoul Singapore Sydney Toronto

The McGraw-Hill Companies

McGraw-Hill books are available at special quantity discounts to use as premiums and sales promotions, or for use in corporate training programs. For more information, please write to the Director of Special Sales, Professional Publishing, McGraw-Hill, Two Penn Plaza, New York, NY 10121-2298. Or contact your local bookstore.

© 2007 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 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 DOC DOC 019876

ISBN-13: 978-0-07-226152-3

ISBN-10: 0072261528

• Sponsoring Editor
  Wendy Rinaldi

• Editorial Supervisor
  Patty Mon

• Project Manager
  Vasundhara Sawhney

• Acquisitions Coordinators
  Alex MacDonald
  Mandy Canales

• Technical Editor
  Todd Meister

• Copy Editor
  Robert Campbell

• Proofreader
  Michael Toporek

• Indexer
  Kevin Broccoli

• Production Supervisor
  George Anderson

• Composition
  International Typesetting and Composition

• Illustration
  International Typesetting and Composition

• Art Director, Cover
  Jeff Weeks

• Cover Designer
  Pattie Lee

Information has been obtained by McGraw-Hill from sources believed to be reliable. However, because of the possibility of human or mechanical error by our sources, McGraw-Hill, or others, McGraw-Hill 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 the use of such information.

Dedication

This book is dedicated to the loving memories of my mother, Elaine Shapiro, my grandparents Beno and Rose Frank, and my great aunt, Phyllis Koppel.

About the Author

Jeffrey Shapiro, MCSE, MCTS, MCPD, is the author of SQL Server 2000: The Complete Reference as well as 11 other technology books. He is currently working on a variety of SQL Server business intelligence projects for Fortune 100 companies in Orlando, Florida.

Acknowledgments

I have often imagined what it must be like for a sailor, stranded alone on a small yacht in the middle of a giant, angry ocean. Besides the loneliness there is that ever present danger that something will go bump in the night, and your boat will go down with you in it, food for the sharks, or for some giant squid that’s waiting with hungry tentacles,

This book was completed over a period of five and a half months that were spread out over 18 months thanks to Hurricanes Wilma and Katrina in the summer and fall of 2005, and often I felt like that desperate sailor trapped in my lab surrounded by eight SQL Server machines, which at times seemed more like the life-threatening tentacles of that giant calamari lurking beneath the waves, especially when they don’t work when you are out of power,

Fortunately, just as the boat seemed to take on water the lifelines would get thrown out to me, and the one soul that gets to be promoted to admiral is my wife Kim. Without her support, I would not have made it into safe harbor.

As any seafaring person knows, there is always a beacon of light guiding the way, The lighthouse of my life is my son Kevin, who is always there to calm me down enough that I may see the rocks and get through troubled waters, with a smile you hear from ten thousand miles away-beats the foghorn any day.

McGraw-Hill has a very special editing team that has made this book possible, They are led by Editorial Director, Wendy Rinaldi, to whom I am indebted for the opportunity to do this book and be part of McGraw-Hill’s vision for excellence in technical publications.