Microsoft SQL Server 2005 New Features

Michael Otey

McGraw-Hill/Osborne
2100 Powell Street, 10th Floor
Emeryville, California  94608
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.

Microsoft^® SQL Server^™ 2005 New Features

Copyright © 2005 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 FGR FGR 01987654

ISBN 0-07-222776-1

Vice President & Group Publisher
Mike Hays

Vice President & Publisher
Scott Grillo

Acquisitions Editor
Wendy Rinaldi

Project Editor
Julie M. Smith

Acquisitions Coordinator
Alex McDonald

Technical Editor
Tom Rizzo

Copy Editor
Bob Campbell

Proofreader
Susie Elkind

Indexer
Valerie Perry

Composition
Elizabeth Jang, Dick Schwartz

Illustrators
Kathleen Edwards, Melinda Lytle

Series Design
Peter F. Hancik

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 the use of such information.

Acknowledgments

I’d like to acknowledge all of the help from the great people at Osborne who made this book possible. Wendy Rinaldi planted the seed for this book on SQL Server 2005’s new features and gave me the encouragement to grow it from an idea into a full fledged book. Julie Smith, the book’s project editor, juggled a hectic schedule and a stream of new material, revisions, and edits as she managed the tough task of bringing all of the material for the book together. I’m also thankful for the efforts of copy editor Bob Campbell, proofreader Susie Elkind, indexer Valerie Perry, and Elizabeth Jang and Dick Schwartz for page composition.

I also got substantial help from Tom Rizzo and Eric Brown who provided essential technical reviews. Their efforts helped me to keep up with the rapidly evolving product as it moved through its prerelease and beta cycles. To the degree this book meets my goals of technical excellence; I owe a lot to Tom and Eric. Of course, I take responsibility for any errors that may remain in the final version.

And I’d also like to give a special thanks to my wife, and not-so-silent partner, Denielle Otey, one of the book’s technical editors. She rigorously tested and retested all of the code samples used in the book as well as giving me advice and support throughout the project.

Michael Otey

About the Author

Michael Otey is the Technical Director for Windows ITPro Magazine and Senior Technical Editor for  SQL Server Magazine. He is also President of TECA, Inc (www.teca.com), a software development and consulting company that specializes in networking and database applications. Michael is the co-author of the SQL Server 2000 Developer’s Guide and the ADO.NET: The Complete Reference published by McGraw Hill/Osborne.

Dedication

This book is dedicated to my Mom who planted in me the faith to tackle life’s challenges and problems.

Michael Otey