The Fun and Easy Way'M
`to Develop a Database
`System Tailored to
`Your business Needs
`Your First Aid Kit°
`for Deploying and
`Managing Network
`Databases
`Web Publishing and
`- Security Concerns —
`,~~
`,,,
`Explained in Pain English
`°~° `
`~,F ~~a
`
`i t ~ r 4PANK~a' S~-LVIOIff~~
`
`1
`
`A Re erence or
`e Rest o Us.
`by Anthony T. Mann ' ~/
`~..
`
`~~
`
`BOOKS
`
`WORLD\V[DG
`
`~~-~,,.,,4e,;,.~-.9
`
`Snap's Exhibit No. 1005
`0001
`
`

`

`
`
`Facebook's Exhibit No. 1005
`
`0002
`
`Snap's Exhibit No. 1005
`0002
`
`

`

`Exclusive
`SQL Seruer 7
`"Cheat Sheet"
`Inside!
`~~
`
`Illllllll~lllllll~llllillllllllll~ I INGRESS
`Get All the L
`Microsoft SQL S O ~~~~~~~~~~~~~~~~~~I~~~~~~~~~~
`None of the c~___0~3 869 259 6
`
`With its new built-in management
`tools, scores of extra wizards, and
`support for the latest database stan-
`dards, Microsoft SQL Server 7 is hotter
`thau ever. And you don't have to lose
`your sanity or give up your weekends
`to figure out how to use it. With the
`expert advice of SQL Server 7 guru
`Anthony Mann, you'll quiclzly and
`easily develop the expertise you need
`to build, deploy, and manage a reliable,
`scalaUle database system that can
`handle your entire business —and
`grow with it.
`Inside, find helpful advice
`on how to:
`• Install Microsoft SQL Server 7 without
`any headaches
`• Create SQL Server objects using wizards, the
`Enterprise Manager, and the Query Analyzer
`• llevelop and use stored procedures
`• Use SQL to put Microsoft SQL Server 7
`to work
`• Save time by automating tasks with Jobs
`and Alerts
`• Impost and export data to and from an SQL
`Server database
`• Secure and backup your data
`• Publish documents to the Web
`
`Let These Icons Guide You!
`.~~P
`Points out shortcuts and
`insights that save you time
`and trouble
`
`QNIN G/
`3P ``- l Alerts you to potential
`problems you should
`~~
`watch out for
`Introduces you to SQL
`J~'G~
`~~~a~ Server terminology
`
`About Anthony T. Mann
`Anthony T. Mann, a partner in Shategic
`Innovations Consulting, Inc., a Denver-
`based consulting firm, has many years of
`experience developing and teaching
`client/server applications with Microsoft
`SQL Server. He holds Microsoft certifications
`in SQL Server, Visual Basic, Windows NT,
`and Windows architecture.
`
`Technical Review
`by Michael Watterud
`Senior Consultant
`Microsoft, Indianapolis, IN
`
`"`
`
`Microsoft antl the Microsoft Internet Explorer logo are registered
`trademarks or trademarks of Microsoft Corporation in the United
`States and/or other countries.
`The IDG Books Worldwide logo is a trademark under exclusive license
`to IDG Books Worldwide, Inc., from International Data Group, Inc. The
`Fun and Easy Way and the ...For Dummies logo are trademarks, and
`Dummies Man, — ---For Dummies, A Reference for the Rest of Us!,
`Your first Aid Kit, and ...For Dummies are registered trademarks of
`IDG Books Worldwide; Inc.
`Printed in the U.S.A.
`
`~
`
`Must-Have
`SQL
`Server 7
`Tools on
`CD-ROM:
`• Vision Builder trial
`version: Model complex
`business logic
`Internet Explorer:
`~ Inclutles
`A popular Web
`Mme. browser from
`In[eme[ Microsoft
`Explorer
`• sp~lssist evaluation
`version: Greate, edit, and
`manipulate stored proce-
`dures within SQL •Server
`Shareware programs are fully functional, free
`trial versions of copyrighted programs. h you
`like partcular programs, register with tAeir
`auMors for a nominal Pee and receive
`Ncenses, enhanced versions, and technical
`support. Freeware programs are free, capy-
`rightedgames, applications, and udGtres. You
`can copy them to as many PCs as yaulike —
`free —but they here no technical support.
`SYSTEM REQUIREMENTS: Pentium 100 a lister
`PC with Wlndonus 95, 98, or NT 4.0 a later;
`1 BMB RAM (32 recommended; double speed
`(2x) or faster CD-ROM; and MS SQL Serve
`
`..~ r~AtlN
`my2cents.dummies.com '.
`WLMis
`
`READER LEVEL
`Ihutuiues Pres,S
`'
`Beginning to Intermediate
`~ a division of
`COMPUTER BOCK SHELVING CATEGORY B~~ ~~~ R°nks worldwide, roc.
`~n mrer~at~o~~i
`sooxsen~s
`Networkin S L Server
`Data Group Company
`FROb11DG
`g~ Q
`see ns at:www.daunnies.com
`52x.99 USA
`~Z.~. Ci8118Q8~~Z8.~ ~1IC~. VAT UK
`fur info on other IDG books titles:
`www.iagUooks.com
`
`z 85555 50416
`
`s
`
`ISBN 0-7645-0416-9
`5 2999
`
`9 780764 504167
`
`Snap's Exhibit No. 1005
`0003
`
`

`

`;~(«rasa f t~ Sd L Server 7
`Q,
`Far l~~rrr~m~es
`
`C~~~' ~,
`yw°~
`
`BOOKSERIFS
`F(tOM IDG
`
`~ticruso f t SUL Server 7.0 pataty~es
`Description
`Datarype
`Fixed-length binary data
`binary
`Integer data, holding a boolean value of either D or 1
`bit
`Fixed-length non-Unicode character data
`char
`Date and time data from January 1, 1753, to
`datetime
`December 31, 9999, with a 3/100 second accuracy
`Fixed precision and scale numeric data for up to 38 digits
`
`decimal
`
`float
`
`image
`int
`
`money
`
`nchar
`ntext
`nvarchar
`real
`smalldatetime
`
`smallint
`smallmoney
`
`text
`tinyint
`varbinary
`varchar
`
`Floating precision number data for up to 15 digits
`
`Variable-length binary data
`Integer (whole number) data from -2,147,483,648 to
`+2,147,483,647
`Monetary data values from -922,337,203,685,477.5808 to
`+922,337,203,685,477.5807, with a 4 decimal place accuracy
`Fixed-length Unicode data
`Variable-length Unicode data
`Variable-length Unicode data
`Floating precision number far up to 7 digits
`Date and time data from January 1, 1900, through
`June 6, 2079, with a 1 minute accuracy
`Integer data from -32,768 to +32,767
`Monetary data values from -214,748.3648 to +214,748.3647,
`with a 4 decimal place accuracy
`Variable-length non-Unicode data
`Integer data from 0 to 255
`Variable-length binary data
`Variable-length non-Unicode data
`
`Storage size (in bytes)
`<_ 8,000
`1 for 8 bits
`5 8,000
`8
`
`5, 9,13, or 17,
`depending on
`precision
`4 or 8, depending on
`precision
`~ 2,147,483,647
`4
`
`8
`
`S 4,000
`51,073,741,823
`<_ 4,000
`4
`4
`
`2
`4
`
`5 2,147,483,647
`1
`<_ 8,000
`<_ 8,000
`
`rn
`
`CopyrightO 1998 IDG Boaks Worldwide, fnc.
`All rights reserved.
`
`IDG Cheat Sheet $2.95 value. Item 0416-9.
`
`BOOS For more information about IDG Books,
`calll-800-762-2974.
`WORLDWIDE
`
`...Far 1Jumirrries: l~estse ~~in~ 13avk Series far ~3ee~~n~ers~
`
`Snap's Exhibit No. 1005
`0004
`
`

`

`•
`
`n~
`
`600KS@IFS
`FROM IDG
`
`~crasa~~ SC1~ Server 7
`4
`Q ~~~ ~~ ~{
`Far ~3ur~rr~~es
`~~ ~~
`
`r---
`
`V
`
`:ntew~rise Manager
`~ts~r~s~~t S ,~ ~e~ve~° x.01
`Properties
`-Up one level
`Show/hide console tree
`Run a wizard
`Register server
`
`Tree of SQL
`server objects
`
`Delete
`
`Forward
`
`Action menu Tools menu
`
`Refresh
`
`Selection details—
`
`Back
`View menu
`i i
`
`New database New login New job
`New
`i ~
`i
`i
`
`ru ~~,~
`
`~~~ F~~
`
`y-~j f~ficraoftSQLSsrver.,
`,.c :~ 54L 5a~uer Group
`.- r NkSHU.C. ~t✓v~daws A! i J
`ifi~ ~+w.+. 7rancariian f ~~+y~tr.:.'n~ rc —
`• w ~ ~ri-+.-'
`
`~ ' _..
`
`Save
`query/
`result
`
`JLt~~r~s~ f ~ SOL Servea~ ~a ~ uerr~ AnaP~zer
`Clear query
`window Query options
`Execute query
`Execute query into grid
`Display SQL execution plan
`Rs
`Perform index analysis
`Cancel executing query Quer
`Hide results pane Database
`
`Load
`SQL
`script
`
`New
`q l ery
`
`r
`
`X
`
`The norm»an~f [st completed auc~es: Pu12y.
`
`~
`Results Rew~sGiid 54LExrcuuoreRkn
`
`~
`
`~
`
`1 Vi
`
`...far pumrr~~es: 13estse«i~q 1~aok Series far l~egirrr~ers
`
`~llifl WAR.Rlf
`
`-~~....~,.......u~...~waera~w~..
`
`f
`
`Y
`
`Snap's Exhibit No. 1005
`0005
`
`

`

`TM
`
`!Ze ere e ar th
`e
`rrc s
`nest a us!°
`~~
`BESTSELLING Are you intimidated and confused by computers? Do you find
`BOOK SERIES that traditional manuals are overloaded with technical details
`you'll never use? Do your friends and family always call you to
`FROMIDG ~x simple problems on their PCs? Then the . ..For DummiesA
`computer book series from IDG Books Worldwide is for you.
`...For Dummies books are written for those frustrated computer users who know they
`aren't really dumb but find that PC hardware, software, and indeed the unique vocabulary of
`computing make them feel helpless. ...For Dummies books use a lighthearted approach,
`a down-to-earth style, and even cartoons and humorous icons to diffuse computer novices'
`fears and build their confidence. Lighthearted but not lightweight, these books are a perfect
`survival guide for anyone forced to use a computer.
`
`'°I like my copy so much !told
`friends; now they bought copies °°
`—Irene C., Orwell, Ohio
`
`„Thanks, l needed this book Novi
`can seep atnight."
`— Robin f., British Galumbia, Canada
`
`°°wick, concise, nontechnical,
`and hu~reorous."
`— JayAe, E/burn, Illinois
`
`Already, millions of satisfied readers agree. They have
`made ...For Dummies books the #1 introductory level
`computer book series and have written asking for more.
`So, if you're looking far the most fun and easy way to
`learn about computers, look to ...For Dumrr►ies books to
`give you a helping hand.
`
`~~TM
`~-
`~-
`
`~—
`
`BOOKS
`
`WORLDWIDE
`
`Snap's Exhibit No. 1005
`0006
`
`

`

`MICROSOFT?"
`50L SERVER 7
`
`DUMMIE5®
`
`FGR
`
`_~
`
`
`
`Facebook's Exhibit No. 1005
`
`0007
`
`Snap's Exhibit No. 1005
`0007
`
`

`

`by Anthony T. Mann
`}:~
`
`-fir TM
`
`~~
`~~
`
`~~IDG
`BOOKS
`
`WORLDWIDE
`
`IDG Books Worldwide, Inc.
`An International Data Group Company
`
`Foster City, CA ♦Chicago, IL ♦Indianapolis, IN ♦New York, NY
`
`Snap's Exhibit No. 1005
`0008
`
`

`

`~
`
`~
`
`-
`
`_
`
`.~
`~ t
`' ~ ~
`~' ,
`
`r~>,
`' '~:
`
`Microsoft SQL Server 7 For Dummies
`Published by
`IDG Books Worldwide, Inc.
`An International Data Group Company
`919 E. Hillsdale Blvd.
`Suite 400
`Foster City, CA 94404
`www. i dgbooks. com (IDG Books Worldwide Web site)
`www. dummi es . com (Dummies Press Web site)
`Copyright O 1998 IDC Books Worldwide, Inc. All rights reserved. No part of this book, including interior design,
`cover design, and icons, may be reproduced or transmitted in any form, by any means (electronic, photocopying,
`recording, or otherwise) without the ptio~ w.~itten permission of the publisher.
`Library of Congress Catalog Card o.: 98-86185
`ISBN:O-7645-0416-9
`~~.,~-x
`Printed in the United States of America
`10987654321
`10/RS/RQ/ZY/IN
`Distributed in the United States by IDG Books Worldwide, Inc.
`Distributed by Macmillan Canada for Canada; by Transworld Publishers Limited in the United Kingdom; by IDG
`Norge Books for Norway; by IDG Sweden Books for Sweden; by Woodslane Pty. Ltd. for Australia; by Woodslane
`(NZ) Ltd. for New Zealand; by Addison Wesley Longman Singapore Pte Ltd. for Singapore, Malaysia, Thailand,
`Indonesia and Korea; by Norma Comunicaciones S.A. for Colombia; by Intersoft for South Africa; by International
`Thomson Publishing for Germany, Austria and Switzerland; by Toppan Company Ltd. for Japan;.by Distribuidora
`Cuspide for Argentina; by Livraria Cultura for Brazil; by Ediciencia S.A. for Ecuador; by Ediciones ZETA S.C.R. Ltda.
`for Peru; by WS Computer Publishing Corporation, Inc., for the Philippines; by Unalis Corporation for Taiwan; by
`Contemporanea de Ediciones for Venezuela; by Computer Book &Magazine Store for Puerto Rico; by Express
`Computer Distributors for the Caribbean and West Indies. Authorized Sales Agent: Anthony Rudkin Associates for
`the Middle East and North Africa.
`For general information on IDG Books Worldwide's books in the U.S., please call our Consumer Customer Service
`department at 800-762-2974. For reseller information, including discounts and premium sales, please call our
`Reseller Customer Service department at 800-434-3422.
`For information on where to purchase IDG Books Worldwide's books outside the U.S., please contact our
`International Sales department at 650-655-3200 or faze 650-655-3297.
`For information on foreign language translations, please contact our Foreign &Subsidiary Rights department at
`650-655-3021 or fax 650-655-3281.
`For sales inquiries and special prices for bulk quantities, please contact our Sales department at 650-655-3200 or
`write to the address above.
`For information on using IDG Books Worldwide's books in the classroom or for ordering examination copies,
`please contact our Educational Sales department at 800-434-2086 or fax 317-596-5499.
`For press review copies, author interviews, or other publicity information, please contact our Public Relations
`department at 650-655-3000 or fax 650-655-3299.
`For authorization to photocopy items for corporate, personal, or educational use, please contact Copyright
`Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, or fvc 978-750-4470.
`LIMIT OFLIABILITY/DISCLAIMER OF WARRANTY: AUTHOR AND PUBLISHER HAVE USED THEIR BEST EFFORTS
`IN PREPARING THIS BOOK. IDG BOOKS WORLDWIDE, INC., AND AUTHOR MAKE NO REPRESENTATIONS OR
`WARRANTIES W1TH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS BOOK AND
`SPECIFICALLY DISCLAIM ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR
`PURPOSE. THERE ARE NO WARRANTIES WHICH EXTEND BEYOND THE DESCRIPTIONS CONTAINED IN THIS
`PARAGRAPH. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES REPRESENTATIVES OR WRITTEN'.
`SALES MATERIALS. THE ACCURACY AND COMPLETENESS OF THE INFORMATION PROVIDED HEREIN AND THE'
`OPINIONS STATED HEREIN ARE NOT GUARANTEED OR WARRANTED TO PRODUCE ANY PARTICULAR RESULTS,
`AND THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY INDIVIDUAL.
`NEITHER IDG BOOKS WORLDWIDE, INC., NOR AUTHOR SHALL BE LIABLE FOR ANY LOSS OF PROFIT OR ANY
`OTHER COMMERCIAL DAMAGES, INCLUDING BUT NOT L[MITED TO SPECdAL, INCIDENTAL, CONSEQUENTIAL,
`OR OTHER DAMAGES.
`Trademarks: All brand names and product names used in this book are trade names, service marks, trademarks,
`or registered trademarks of their respective owners. IDG Books Worldwide is not associated with any product or
`vendor mentioned in this book.
`ter„,
`
`~ , , ~ '`
`." ~`~
`
`'; ``~
`~ ' ' ~
`
`}
`~,
`~~
`
`_
`
`___.~,
`
`r-
`~t N ~
`
`~ ; ``,
`
`~ ~'
`
`~~
`~
`
`—~ is a trademark under exclusive
`
`IDG license to IDG Books Worldwide, Inc.,
`BOOKS
`
`from International Data Group, Inc.
`
`WORLDWIDE
`
`_..____
`
`Snap's Exhibit No. 1005
`0009
`
`

`

`-
`
``"" ,-x {.~
`
`<, {: _~, :, - -.-
`
`4 ' . r 4 r .'
`
`~ „ ~r
`
`''
`~~ ~~' ~'~.
`'~
`
`~ ~~
`
``3=...~
`~~~"Y
`
`, a ; ...
`. .a
`..~'_~.....,.,:~
`
`'~''
`
`-~
`~ k '~
`
`Microsoft SQL Server 7 For Dummies
`Published by
`IDG Books Worldwide, Inc.
`An International Data Group Company
`919 E. Hillsdale Blvd.
`Suite 400
`Foster City, CA 94404
`w ww . i d g b o o k s . c om (IDG Books Worldwide Web site)
`w ww .dummies . c om (Dummies Press Web site)
`~.
`Copyright O 1998 IDG Books Worldwide, Inc. All rights reserved. No part of this book, including interior design,
`cover design, and icons, may be reproduced or transmitted in any form, by any means (electronic, photocopying,
`recording, or otherwise) without the prior written permission of the publisher.
`Library of Congress Catalog Card No.: 98-86185
`ISBN: 0-7645-0416-9
`Printed in the United States of America
`10987654321
`1 O/RS/RQ/ZY/IN
`Distributed in the United States by IDG Books Worldwide, Inc.
`Distributed by Macmillan Canada for Canada; by Transworld Publishers Limited in the United Kingdom; by IDG
`Norge Books for Norway; by IDG Sweden Books for Sweden; by Woodslane Pty. Ltd. for Australia; by Woodslane
`(NZ) Ltd. for New Zealand; by Addison Wesley Longman Singapore Pte Ltd. for Singapore, Malaysia, Thailand,
`Indonesia and Korea; by Norma Comunicaciones S.A. for Colombia; by Intersoft for South Africa; by International
`Thomson Publishing for Germany, Austria and Switzerland; by Toppan Company Ltd. for Japan; by Distribuidora
`Cuspide for Argentina; by Livraria Cultura for Brazil; by Ediciencia S.A. for Ecuador; by E~ciones ZETA S.C.R. Ltda.
`for Peru; by WS Computer Publishing Corporation, Inc., for the Philippines; by Unalis Corporation for Taiwan; by
`Contemporanea de Ediciones for Venezuela; by Computer Book &Magazine Store for Puerto Rico; by Express
`Computer Distributors for the Caribbean and West Indies. Authorized Sales Agent: Anthony Rudkin Associates for
`the Middle East and North Africa.
`For general information on IDG Books Worldwide's books in the U.S., please call our Consumer Customer Service
`department at 800-762-2974. For reseller information, including discounts and premium sales, please call our
`Reseller Customer Service department at 800-434-3422.
`For information on where to purchase IDG Books Worldwide's books outside the U.S., please contact our
`International Sales department at 650-655-3200 or fax 650-655-3297.
`For information on foreign language translations, please contact our Foreign &Subsidiary Rights department at
`650-655-3021 or fax 650-655-3281.
`For sales inquiries and special prices for bulk quantities, please contact our Sales department at 650-655-3200 or
`write to the address above.
`For information on using IDG Books Worldwide's books in the classroom or for ordering examination copies,
`please contact our Educational Sales department at 800-434-2086 or fax 317-596-5499.
`For press review copies, author interviews, or other publicity information, please contact our Public Relations
`department at 650-655-3000 or fax 650-655-3299.
`For authorization to photocopy items for corporate, personal, or educational use, please contact Copyright
`Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, or fax 978-750-4470.
`LIMIT OF LIABILITY~DISCLAIMER OF WARRANTY: AUTHOR AND PUBLISHER HAVE USED THEIR BEST EFFORTS
`IN PREPARING THIS BOOK. IDG BOOKS WORLDWIDE, INC., AND AUTHOR MAKE NO REPRESENTATIONS OR
`WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS BOOK AND
`SPECIFICALLY DISCLAIM ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR
`PURPOSE. THERE ARE NO WARRANTIES WHICH EXTEND BEYOND THE DESCRIPTIONS CONTAINED IN THIS
`PARAGRAPH. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES REPRESENTATIVES OR WRITTEN
`SALES MATERIALS. THE ACCURACY AND COMPLETENESS OF THE INFORMATION PROVIDED HEREIN AND THE
`OPINIONS STATED HEREIN ARE NOT GUARANTEED OR WARRANTED TO PRODUCE ANY PARTICULAR RESULTS,
`AND THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY INDIVIDUAL.
`NEITHER IDG BOOKS WORLDWIDE, INC., NOR AUTHOR SHALL BE LIABLE FOR ANY LOSS OF PROFIT OR ANY
`OTHER COMMERCIAL DAMAGES, INCLUDING BUT NOT LIMITED TO SPECIAL, INCIDENTAL, CONSEQUENTIAL,
`OR OTHER DAMAGES.
`Trademarks; All brand names and product names used in this book are trade names, service marks, trademarks,
`or registered trademarks of their respective owners. IDG Books V~orldwide is not associated with any product or
`vendor mentioned in this book.
`—~—~,
`
`.s~ ~j~
`
`~ ~
`
`~
`
``ib.i'.
`
`—~ is a trademark under exclusive
`
`ID~ license to IDG Books Worldwide, Inc.,
`j from International Data Group, Inc.
`BOOKS
`
`WORLDWIDE
`
`Snap's Exhibit No. 1005
`0010
`
`

`

`Abaut the Authar
`
`Anthony T. Mann has been developing and instructing in the field of Client/
`Server architecture and technology for many years. He holds the Microsoft
`Certified Solution Developer (MCSD) credential and is working on achieving
`the Microsoft Certified Systems Engineer (MCSE) credential.
`Anthony is Senior Vice-President/CTO of Strategic Innovations Consulting,
`Inc. (SIC). SIC is headquartered in Denver, Colorado, with an office in the
`Boston area and coming soon to a city near you (Houston, Atlanta, 1Vew
`York City, and San Jose). SIC specializes in client/server computing solutions
`via LAN or Web. SIC offers full outsourcing services, as well as on-site
`complete solutions including design, development, integration, testing,
`training, documentation, and more. For more information about SIC, please
`visit www. strategi c -innovations . com.
`Anthony is a veteran author of many Visual Basic books, published by SAMS,
`including Real-World Programming with Visual Basic, Visual Basic 4
`Developer's Guide, Real-World Programming with Visual Basic 4, Visual Basic 5
`Developer's Guide, and Visual Basic 5 Development Unleashed. This is his
`first (hopefully of many) ...For Dummies book. He can be e-mailed at
`tma n n@v ba s i c . com. He lives in southeastern New Hampshire with his wife
`and two shelties.
`
`Snap's Exhibit No. 1005
`0011
`
`

`

`.~~ov~r i~ soox~s wow►
`
`"~
`
`r
`
`Welcome to the world of lDG Books Worldw9de.
`IDt~ Books Worldwide, Ittc., is a subsidiary of internarional Data Group,.the world's largest publisher at
`computer-related information and the leading global provider oEinforniation services on information technolag}:
`IDG was founded more -than 25 years ago and now employs more than 8,500 people worldwide. IDG Publishes
`more than 275 computer publications in over 75 countries (see listing below}. More than 90 million people
`read one or more IDG publications each month.
`Launched in 1990, IDG Books Worldwide is today the #1 publiSheroE'best-selitng computer books in [he
`United States. We are proud to have received eight awards from the Computer Fress Association in recognition
`of editorial excellence and three feom Computer Cun~nts' First Annual Readers' Choice Awards. Our best-
`selling ... For Dummies series has more than 50 million copies in print with translations in 381anguages. [DG
`Books Worldwide, through a joint venture with IDG's Hi-Tech Beijing, became the first U.S. publisher to
`publish a computer book in the People's Republic of China. I~ record time, IDG Books Worldwide has become
`the iirsc choice for millions of readers around the.warld who want to learn how to better manage their
`businesses.
`Our mission is simple: Every one of our books is designed to bring emra value: and. skill-building instractfons
`to the reader. Our books. are written by experts who understand and care about our readers. The knowledge
`base of our editorial staff comes from years of experience in publishing,. education, and joumalisrn —
`e~aerience we use. to prod~zce books for the '90s. in short, we care about books, so we attract the best people.
`We devote special attention to details such as audience, interiordesign, use of icons, and illustrations. A~~d
`bEcause we use an eFficient process of authori[~g, editing, and desktop pu6iishing our books electronically,
`we can spend mare time ensuring superior content and spend Iess time on the: technicalities of making bnoks.
`You can count un our commitment to deliver high-quality books at competitive prices on topics you want
`to read about. Ac 1DG Books Worldwide, we continue in the tDG tradition of delivering quality for more than
`25 years. Yau'}t find no better book on a subject than one €rom tDG Books Worldwt8e.
`
`'~,~:
`
`~ ~
`
`John Kilcullen
`GEO
`[DG Books Worldwide, Inc.
`
`Seven Bc.rkowi~~
`President and Publisher
`tDG Boolzs Worldwlcle, I '
`
`VIII
`
`WINNER
`
`Elgd[!t Amtua!
`Computer Press
`Awards
`1992
`
`~_
`~~~
`
`-
`
`T~
`11 1
`WINNER
`
`Niafle Aimual
`Computer Press
`Awards
`1993
`
`~~~u~s ~
`
`~Q4p~ O\~.
`
`j~
`
`y~~
`
`WINNER
`
`Tenik Amma1
`Compiler Press
`Awards~1994
`
`~ ~
`~~
`
`XI
`
`WINNHR
`
`E[evenfh Aneual
`Computer Press
`Awards ~I995
`
`•~
`
`1
`
`~
`
`j
`
`1It ~
`
`~
`
`I~G Books Worldwide, Inc., is a sibsidiary of lntemational Data Group, the world's largest publisher ofcomputer-related information and the leading global provider of in(ormatian services on information rechnotogy. Inrema~ional
`Data Group publishes over 275 compwer publications in over 75 countries. More than 90 million people read one or more International ~a[a Group publications each month. International Data Gronp's publications include:
`ARGENi1NA: Buyers Guide, Compwetworld Argentina, PC World A~genlina; AUSTRALIA: Australian Maavodtl, Australian PC World, Australian Reseller News, Computenvodd, lT Casebook, Netrvork World, Publish, 4~ebmaste~;
`AUSiR1A: Compurenvelt Osterteich, Networks Austria, PC Tip Austria; BANGLADESH: PC World Bangladesh; BELARUS: PC World 8elanas, 6ELGIUM: Data News; B&AZIL: Annu9rio de Inform9tica, Compmerwodd, Connections,
`Maavodd, PC Player, PC World, Publish, Reuller Nnvs, Supergamepower, BULGARIA: Compurenvorld Bulgaria, Network World Bulging, PC dT MuWorld Eulgaria; CANADA: CIO Canada, ClienVServer World, CompumrWorld
`Canada.lntoWorld Canada, NenvorkWodd Canada, WebWorld; CHfLE: Computenvorld Chile, PC World Chile; COLOMBIA: Computenvorid Colombia. PC World Colombia; COSTA RICA: PC World Centro America; THE
`CZECH AND SLOVAK REPUBLICS: Compurervodd Qechoslovakia, M~cwodd Czech Republic, PC World Czechoslovakia; DENMARK: Communications World Danmark, Computenvorld Danmark, Manvodd Danmark, PC
`Nbrld Danmark, Techwodd Denmark; DOMINICAN REPUBLIC: PC World Republica Dominicans; ECUADOR PC World Ecuador. EGYPC: Computerworld Middle Eas[, PC World Middle Eul; EL SALVADOR: PC World Centro
`America; FINLAND: MikroPC, Tietoverkkq iietoviikko; FRANCE: Distributique, Hebdo, Info PC, Le Monde lnformatigae, Maowrld, Reseaux & Telecoms, WebMazter France'. GERMANY: Compucer Partner, Computenvoche,
`Compnterwoche Extra, Compurerwoche FONS, Global On(ine, Maovelt, PC Welt; GREECE: Amiga Computing, GamePro Greece, Multimedia Wvdd; GUATEMALA; PC World Centro America; HONDURAS: PC World Centro
`America; HONG BONG: Computenvodd Hong Kong, PC World Hang Kong, Puhlish in Asia; HUNGARY: ABCD CD-ROM, Canpurenvorld Szamitastechnika, Intemetto online Magazine, PC World Hungry, PGX Magazin Hungary;
`ICELAND, Tolniheimur PC World Island; INDIA: lnform~tion Communications World, In(oemation Systems Compurerwodd, PC World India, Publish in Asia; INDONESIA: InfoKompwer PC World, KomPutek Computerworld,
`Publish in Asia, IRELAND: CompucerScope, PC Live!; ISRAEL: Manvorld Israel, People ~ Coinpurers/Compurenvorld; ITALY: Computerworld Italia, M~cworld Iloilo, Netrvorking Italia, PC World Italia; JAPAN: DTP World,
`Macwodd Japan, Nikkei Personal Compwing, OS2 World Japan, SunWodd Japan, Windows NT World, Wmdoas World Japan; KENYA: PC World Easi A(ncan; KOREA: Hi-tech information, Macwodd Korea, PC World Korea;
`MACEDONIA: PC World Macedonia; MAI.AYStA: Compmenvodd Malaysia, PC World Malaysiz, Publish in Asia; MALiA; PC World Malta; MEXICO: Compuienvorld Mexim, PC World Mexico; MYANMAR: PC World Myanmar,
`NETHERLANDS: Compnler! Totaal, IAN Intemetworking Magazine, lAN World Buyers Guide, Maavodd Netherlands, Net, WehWereld: NEW ZEALAND: Absolute Beginners Guide and Plain &Simple Series, Computer Buyer,
`Campnter Industry Directory, Compumrxodd New Zealand, MiB, Network Worfd, PC World Ne~v Zealznd; NICARAGUA: PC World Centro America; NORWAY: Computenvodd Norge, CW Rapport, Dalamagasinet, Financial
`Rapport, Kursguide Norge, Macworld Norge, Nultimediawodd Norge, PC World Ekspress Norge, PC World Nettverk, PC World Norge, PC World ProduktGuide Norge; PAI(ISTAN: Computenvodd Pakistan; PANAMA: PC World
`Panama; PEOPLE'S REPUBLIC OF CHINA: China Computer Users, China Compurerv+orld, China In(oWodd, China ietemm World Weekly, Computer 6 Communication, Electronic Design China, Electronics Today, Electronics
`Weekly, Game Sotnvare, PC World China, Popular Computer Week, Software Weekly, Software World, Telewm World; PERU: Computenvorld Peru, PC World Profesional Peru, PC World SoHo Peru; PHILIPPINES: Click!,
`Compnterwodd Philippines, PC World Philippines, Publish in Asia; POLAND: Compumrworld Poland, Computernorld Special Report Poland, Cyber, Maavodd Poland, Nenvodd Poland, PC Nbrld Komputer, PORTUGAL
`Cere6roRC World, Computerworld~Correio lnform8tico, Dealer Nbrld Portugal, Ma~'InlPC'In Portugal, Mtdtimedia World, PUERTO R1C0: PC World Puerto Rico; ROMANIA: Computelworld Romania, PC Nbrld Romania,
`Telecom Romania; RUSSIA: Computenvodd Russia, Mir PK. Publish.5eti: SWGAPORE: Computenvodd Singapore, PC World Singapore. Publish in Asia; SLOVENIA: Monitor; SOUTH AFRICA: Computing SA. Network World
`$A, Software World $A. SPAIN: Communicaciones World Espana, Computefwodd Espana, Dealer World Bspada, A7aavodd Espana, PC World Espzna; SRI LANKA: Infolink PC World; SWEDEN: CAPfs~esigq Compwer Sweden,
`Corporate Computing Sweden, lnternenvodd Sweden, it.brnnschen, Maavodd Sweden, MaxiData Sweden, MikroDatom, Natverk N Kommunikation, PC World Sweden, PCakiiq Windows World Sweden, SWIiZHRLAND:
`Compnrernorld Schweiz, Macwodd Schweiz, PCtip; iA1WAN: Computerworld Taiwan, Macworld Taiwan, NEW Vi5i0N/Publish, PC World Taiwan, Windows World Taiwan; THAILAND: Publish in Asia, Thai Computenvodd;
`TURI(EY: Camputernodd Turkiye, Maawdd Turkiye, Network World Turkiye, PC World Tudciye; UKRAINE: Camputerwodd IGev, Multimedia World Ukraine, PC World Ukraine; UNITED KINGDOM: Acorn User UK, Amiga
`Action UK, Amiga Computing UK, Apple Talk UK, Compusing, Maawrld, Parems and Computers UK. PC Advisor, PC Home, PSX Pro, The WEB: UNITED S7A1'E5: Cable in the Clazsroom, CIO Magazine. Computenvodd, DOS
`World, Federal Computer Week, GamePro Ma~zine, InfoWodd, I-Way, Macwodd, Network World, PC Games, PC World, Publish, Video Event, lHE WEB Magazine, and WebMuler; online webzines: JavnWorld, NetscapeWodd,
`and SunWodd Online; URUGUAY: In(oWorld Umguay; VENEZUELA: Computerworld Venezuela, PC World Venezuela; and VIETNAM: PC World Vietnam.
`S171~8
`
`Snap's Exhibit No. 1005
`0012
`
`

`

`~Jed~cat~an
`
`To the love of my life, companion, and best friend — my wife, Alison. She,
`once again, has given me the support I need to tackle anything. . . .
`
`Authar's Ac(zrtacv~e~(~r~errts
`
`There are so many people I want to thank and acknowledge for efforts in
`putting this book together. Putting one of these things together requires so
`much effort by me (of course), everyone at IDG Books Worldwide, Inc., and
`all the people who put up with me during the process.
`On the home front . . . I wish to thank Alan Ruth (President), and Dr. Daniel
`Price (Director of Business Development), both with Strategic Innovations
`Consulting. As the three of us work very closely to run our business, they
`have put up with my crankiness (this could be stronger, but it is, after all, a
`family book) and irritability over the past six months.
`At IDG, I wish to extend an extra special thanks to Jill Pisoni (Senior Acquisi-
`tions Editor), Bill Helling (Project Editor), Rowena Rappaport (Copy Editor),
`Linda Stark (Copy Editor), Christy Beck (Senior Copy Editor), Phil
`Worthington (Copy Editor), Michael Watterud (Technical Editor), and the
`rest . . . (from Gilligan's Island). The very close interaction with all these
`people is critical to the success of the book.
`
`Snap's Exhibit No. 1005
`0013
`
`

`

`Publisher's Acknowledgments
`We're proud of this book; please register your comments through our IDG Books Worldwide
`Online Registration Form located at http: //my2cents .dummies . com.
`
`Some of the people who helped bring this book to market include the following:
`
`Production
`Associate Project Coordinator: Tom Missler
`Layout and Graphics: Lou Boudreau,
`Linda M. Boyer, J. Tyler Connor, Angela F.
`Hunckler, Brent Savage, Janet Seib
`Proofreaders: Christine Berman, Kelli Botta,
`Betty Kish, Nancy Price, Rebecca Benninger,
`Janet M. Withers
`Indexer: CZ Editorial Service
`
`Acquisitions, Editorial, and
`Media Development
`Project Editor: Bill Helling
`Acquisitions Editor:.iill Pisoni
`Copy Editors: Rowena Rappaport,
`Linda S. Stark, Christine Meloy Beck,
`Phil Worthington
`Technical Editor: Michael Watterud
`Media Development Editor: Marita Ellixson
`Associate Technical Editor: Joell Smith
`Associate Permissions Editor:
`Carmen Krikorian
`Editorial Manager: Kelly Ewing
`Media Development Manager:
`Heather Heath Dismore
`Editorial Assistant: Paul E. Kuzmic
`
`General and Administrative
`IDG Books Worldwide, Inc.: John Kilcullen, CEO; Steven Berkowitz, President and Publisher
`IDG Books Technology Publishing: Brenda McLaughlin, Senior Vice President and
`Group Publisher
`Dummies Technology Press and Dummies Editorial: Diane Graves Steele, Vice President and
`Associate Publisher; Mary Bednarek, Director of Acquisitions and Product Development;
`Kristin A. Cocks, Editorial Director
`Dummies Trade Press: Kathleen A. Welton, Vice President and Publisher; Kevin Thornton,
`Acquisitions Manager
`IDG Books Production for Dummies Press: Michael R. Britton, Vice President of Production
`and Creative Services; Cindy L. Phipps, Manager of Project Coordination, Production
`Proofreading, and Indexing; Kathie S. Schutte, Supervisor of Page Layout; Shelley Lea,
`Supervisor of Graphics and Design; Debbie J. Gates, Production Systems Specialist;
`Robert Springer, Supervisor of Proofreading; Debbie Stailey, Special Projects Coordinator;
`Tony Augsburger, Supervisor of Reprints and Bluelines
`Dummies Packaging and Book Design: Robin Seaman, Creative Director; Jocelyn Kelaita,
`Product Packaging Coordinator; Kavish + Kavish, Cover Design
`
`The publisher would like to give special thanks to Patrick J. McGovern,
`without whom this book would not have been possible.
`
`Snap's Exhibit No. 1005
`0014
`
`

`

`Contents at a G lance
`
`t", s? rs ~:'
`
`.' :': :: ,.,
`
`_.
`
`-;
`
`.<
`
`~. ,, ;g
`
`~~;
`
`r
`
`~:i as
`
`~a
`
`^.°
`
`.x
`
`--,
`
`,., Kb
`
`t rE r
`
`,<.., c.
`
`_
`
`44
`
`., ~.
`
`., c' ., .~ rl t') ~*
`
`t~ e3
`
`;a ~.J
`
`ff
`
`Introductiorr ................................................................. 7
`dart l: ~An Introduction to 1Nicroso ft SOL Server 7 ............ 7
`Chapter 1: A Quick Tour of Microsoft SQL Server 7 Tools ........................................... 9
`Chapter- 2: Installing Microsoft SQL Server 7 ............................................................... 27
`Chapter 3: Why Not Just Use Microsoft Access? .......................................