Table Of ContentЭлектронная библиотека “Либрус” ( http://librus.ru )
Научно-техническая библиотека электронных книг. Первоначально задуманная
как хранилище компьютерной литературы, в настоящий момент библиотека
содержит книжные издания по различным областям знания (медицинские науки,
техника, гуманитарные науки, домашнее хозяйство, учебная литература и т.д.).
Серьезность научно-технических e-book'ов разбавляет раздел развлекательной
литературы (эротика, комиксы, задачи и головоломки).
Основной целью проекта является ознакомление читателей с многообразием
книгопечатной продукции и помощь в выборе действительно стоящей книги для
приобретения у законных издателей, их представителей или в соответствующих
организациях торговли. Для покупки через Internet мы рекомендуем
воспользоваться услугами интернет-магазина “Озон”.
ВНИМАНИЕ!
Данный файл представлен исключительно в ознакомительных целях!
После ознакомления с данной книгой Вы обязаны удалить ее с Вашего компьютера.
В случае несоблюдения данного обязательства, Вы нарушите закон "Об авторском праве
и смежных правах".
Все авторские права сохраняются за правообладателем. По его требованию доступ к
данному электронному документу будет перекрыт. Однако, таким образом, тысячи
потенциальных покупателей так и не узнают о, возможно, нужной и полезной книге.
Авторам и издательствам
Если Вы заинтересованы в рекламе и продвижении Ваших книг на бескрайних
сетевых просторах мы с удовольствием включим их в наш каталог.
1 YEAR UPGRADE
B U Y E R P R O T E C T I O N P L A N
DESIGNING
SQL SERVER® 2000
DATABASES
FOR
net
. ™ENTERPRISE SERVERS
“This book is a solid introduction to a critical FREE Monthly
component of the Windows 2000 Server family. It Technology Updates
will be a valuable title in your IT library.”
—Richard Martin, Database Administrator and Windows DNA
FREE Downloadable
Developer, MCP+I, MCSE, MCSD, MCDBA, MCT
HTML
Dominion Technology Group, Inc.
FREE Membership to
Access.Globalknowledge
Robert Patton, MCDBA, MCSD, MCSE+I, MCP+I
Jennifer Ogle, MCSE, MCNE, Oracle DBA
TECHNICAL EDITOR and CONTRIBUTOR:
Travis Laird, MCSE, MCDBA, A+, Network+, i-Net+, CIW
114_SQL_FM 1/2/01 2:59 PM Page i
s o l u t i o n s @ s y n g r e s s . c o m
With over 1,500,000 copies of our MCSE, MCSD, CompTIA, and Cisco
study guides in print, we have come to know many of you personally. By
listening, we've learned what you like and dislike about typical computer
books. The most requested item has been for a web-based service that
keeps you current on the topic of the book and related technologies. In
response, we have created [email protected], a service that
includes the following features:
(cid:2) A one-year warranty against content obsolescence that occurs as
the result of vendor product upgrades. We will provide regular web
updates for affected chapters.
(cid:2) Monthly mailings that respond to customer FAQs and provide
detailed explanations of the most difficult topics, written by content
experts exclusively for us.
(cid:2) Regularly updated links to sites that our editors have determined
offer valuable additional information on key topics.
(cid:2) Access to “Ask the Author”™ customer query forms that allow
readers to post questions to be addressed by our authors and
editors.
Once you’ve purchased this book, browse to
www.syngress.com/solutions.
To register, you will need to have the book handy to verify your
purchase.
Thank you for giving us the opportunity to serve you.
114_SQL_FM 1/2/01 2:59 PM Page ii
114_SQL_FM 1/2/01 2:59 PM Page iii
DESIGNING
SQL SERVER 2000
DATABASES
. N E T E N T E R P R I S E
FOR
S E R V E R S
114_SQL_FM 1/2/01 2:59 PM Page iv
Syngress Publishing, 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 obtained from 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 inci-
dental or consequential damages arising out from the Work or its contents. 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 case, including backup and other appropriate precautions, when working
with computers, networks, data, and files.
Syngress Media® and Syngress® are registered trademarks of Syngress Media, Inc. “Career Advancement Through
Skill Enhancement™,” “Ask the Author™,” “Ask the Author UPDATE™,” “Mission Critical™,” and “Hack
Proofing™” are trademarks of Syngress Publishing, Inc. Brands and product names mentioned in this book are
trademarks or service marks of their respective companies.
KEY SERIAL NUMBER
001 58PPL99DSE
002 LSKDJ9878M
003 C3N44T8FQ7
004 KJ675HCC25
005 QCUCA94D26
006 PF62XD2G73
007 DT74HH52A4
008 LKJFARY343
009 65SKNSDAD5
010 6487FPS25N
PUBLISHED BY
Syngress Publishing, Inc.
800 Hingham Street
Rockland, MA 02370
Designing SQL Server 2000 Databases for .NET Enterprise Servers
Copyright © 2001 by Syngress Publishing, 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 dis-
tributed in any form or by any means, or stored in a database or retrieval system, without the prior written per-
mission 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
1 2 3 4 5 6 7 8 9 0
ISBN: 1-928994-19-9
Copy edit by: Darlene Bordwell Index by: Robert Saigh
Technical edit by: Travis Laird Page Layout and Art by: Shannon Tozier
Project Editor: Maribeth Corona-Evans Co-Publisher: Richard Kristof
Distributed by Publishers Group West
114_SQL_FM 1/2/01 2:59 PM Page v
Acknowledgments
We would like to acknowledge the following people for their kindness and support
in making this book possible.
Richard Kristof, Duncan Anderson, Jennifer Gould, Robert Woodruff, Kevin
Murray, Dale Leatherwood, Rhonda Harmon, and Robert Sanregret of Global
Knowledge, for their generous access to the IT industry’s best courses, instructors
and training facilities.
Ralph Troupe, Rhonda St. John, and the team at Callisma for their invaluable
insight into the challenges of designing, deploying and supporting world-class
enterprise networks.
Karen Cross, Lance Tilford, Meaghan Cunningham, Kim Wylie, Harry Kirchner,
Bill Richter, Kevin Votel, Brittin Clark, and Sarah MacLachlan of Publishers Group
West for sharing their incredible marketing experience and expertise.
Mary Ging, Caroline Hird, Simon Beale, Caroline Wheeler, Victoria Fuller,
Jonathan Bunkell, and Klaus Beran of Harcourt International for making certain
that our vision remains worldwide in scope.
Anneke Baeten, Annabel Dent, and Laurie Giles of Harcourt Australia for all their
help.
David Buckland, Wendi Wong, Daniel Loh, Marie Chieng, Lucy Chong, Leslie Lim,
Audrey Gan, and Joseph Chan of Transquest Publishers for the enthusiasm with
which they receive our books.
Kwon Sung June at Acorn Publishing for his support.
Ethan Atkin at Cranbury International for his help in expanding the Syngress
program.
Joe Pisco, Helen Moyer, and the great folks at InterCity Press for all their help.
vv
114_SQL_FM 1/2/01 2:59 PM Page vi
From Global Knowledge
At Global Knowledge we strive to support the multiplicity of learning styles
required by our students to achieve success as technical professionals. As
the world's largest IT training company, Global Knowledge is uniquely
positioned to offer these books. The expertise gained each year from pro-
viding instructor-led training to hundreds of thousands of students world-
wide has been captured in book form to enhance your learning experience.
We hope that the quality of these books demonstrates our commitment to
your lifelong learning success. Whether you choose to learn through the
written word, computer based training, Web delivery, or instructor-led
training, Global Knowledge is committed to providing you with the very
best in each of these categories. For those of you who know Global
Knowledge, or those of you who have just found us for the first time, our
goal is to be your lifelong competency partner.
Thank your for the opportunity to serve you. We look forward to serving
your needs again in the future.
Warmest regards,
Duncan Anderson
President and Chief Executive Officer, Global Knowledge
vi
114_SQL_FM 1/2/01 2:59 PM Page vii
Contributors
Robert A. Patton (MCDBA, MCSD, MCSE+I, MCP+I) is a Software
Engineer specializing in Microsoft Windows DNA applications using
Interdev and Visual Basic with Windows 2000 and SQL Server. He is cur-
rently a Senior Applications Developer at PurchasingFirst.com in Dublin,
OH and, in his position there, has done work for First Union National
Bank, Corporate Strategic Services, the Midland Life Insurance Company,
and Sykes Enterprises. Robert attended the University of Chicago, where
he studied Public Policy. He earned his Bachelor of Science degree in
Software Engineering from The Ohio State University. He lives in Dublin,
OH with his wife Jenny and their sons Michael and Alex.
Jennifer Ogle (MCSE, MCP+I, MCNE, Oracle DBA) is Owner and President
of Radioactive Frog Web Designs, Inc. (www.radfrog.com), which specializes
in contract Web site design and development and database administration.
Jennifer has over 20 years of experience in the IT industry, specializing in
government, scientific, and manufacturing applications. Her recent assign-
ments include SQL and Oracle development for Hoover Materials Handling
Group and Lockheed Martin. In addition to her extensive software and
hardware experience, she has programmed with Java, Visual Basic, and
Visual InterDev, among many others. Jennifer lives with her husband Kent
in Knoxville, TN.
Sean Campbell (MCSE, MCDBA, MCSD, MCT) is an Owner of 3 Leaf
Solutions, LLC. He has worked in the education field for 7 years, with 5
years focused on IT training and consulting. Sean has worked with SQL
Server since version 6. He has developed custom training and delivered
MOC training for a number of years on SQL Server and other development
technologies and has authored numerous Microsoft TechNet sessions on
topics such as supporting SQL and upgrading to SQL Server 2000.
Sean’s consulting experiences have run the gamut from database
administration and application upgrades to .NET development. Sean has
been working on projects with Microsoft since early Beta releases of SQL
Server 2000 and has focused on SQL Server 2000’s administration and
implementation enhancements.
vii
114_SQL_FM 1/2/01 2:59 PM Page viii
Mark Horninger (A+, MCSE+I, MCSD, MCDBA) is President and Founder
of Haverford Consultants, Inc. (www.haverford-consultants.com), located in
the suburbs of Philadelphia, PA. He develops custom applications and
system engineering solutions, specializing primarily in Microsoft operating
systems and Microsoft BackOffice solutions. Mark has over 12 years of
computer consulting experience and has passed 26 Microsoft certified
exams. During his career, Mark has worked on many extensive projects
including database development using SQL 6.5, SQL 7, and SQL 2000;
application development; training; embedded systems development; and
Windows NT and 2000 project rollout planning and implementations. Mark
lives with his wife Debbie and two children in Havertown, PA.
Steve Maier (MCSD) is a Senior Software Engineer for Heidelberg Digital
L.L.C. (www.us.heidelberg.com), located in Rochester, NY. He develops
custom PostScript drivers for Microsoft operating systems. Steve has 10
years of computer programming experience in DOS, Windows, and UNIX.
During his career, Steve has done database development, manufacturing
application development, driver development, and game development. He
has also worked on FDA-approved medical software and has taught a
variety of college classes including programming, system analysis, and PC
repair. Steve lives with his wife Lisa and two children in Rochester, NY.
Henk-Evert Sonder (CCNA) has over 15 years of experience as an Infor-
mation and Communication Technologies (ICT) professional, building and
maintaining ICT infrastructures. In recent years, he has specialized in inte-
grating ICT infrastructures with business applications and the security
that comes with it. Currently, Henk works as a Senior Consultant for a
large Dutch ICT solutions provider. His company, IT Selective, helps
retailers get e-connected. Henk has also contributed to other Syngress
books, including the E-mail Virus Protection Handbook (ISBN: 1-928994-
23-7).
Scott Delaney (MCSD, MCDBA, MCSE) is a Senior Consultant with
TurnAround Solutions (www.turnaroundsolutions.com), a leading e-com-
merce consulting and product development firm based in Australia.
TurnAround has a core client list including blue chips and multinationals
and is known for its well-trained staff, processes, and quality development.
In addition to his database work with SQL Server and Oracle, Scott also
develops custom C++ and Java solutions. His current pet project is the
viii
