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