Microsoft KB Archive/823320

= MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition Comments And Corrections =

Article ID: 823320

Article Last Modified on 7/23/2004

-

APPLIES TO


 * MSPRESS MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition, ISBN 0-7356-1960-3

-



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition, 0-7356-1960-3.

The following topcis are covered:


 * Page 72: &quot;sp_helpprotect&quot; Should Be &quot;sp_helprotect&quot;
 * Pages 132 - 134: Correction To Figures 3.14, 3.15, and 3.16
 * Page 320: Incorrect CREATE TRIGGER Sample Statement
 * Page 424: Correction To Set Transaction Isolation Level Samples



Page 72: &quot;sp_helpprotect&quot; Should Be &quot;sp_helprotect&quot;
On page 72, in line 2 and line 18,

Change:

&quot;EXEC sp_helpprotect Investors&quot;

To:

&quot;EXEC sp_helprotect Investors&quot;

Pages 132 - 134: Correction To Figures 3.14, 3.15, and 3.16
On pages 132, 133, and 134, in Figures 3.14, 3.15, and 3.16, change the right top table's name from:

&quot;Authors&quot;

To:

&quot;BookCondition&quot;

Change the table's name from:

&quot;BooksOrders&quot;

To:

&quot;BookOrders&quot;

Change the column name in table OrderStatus from:

&quot;StatusDescip&quot;

To:

&quot;StatusDescrip&quot;

Page 320: Incorrect CREATE TRIGGER Sample Statement
On page 320, under &quot;Creating Triggers Using Transact-SQL&quot;,

Change:

&quot;CREATE TABLE trigger_name&quot;

To:

&quot;CREATE TRIGGER trigger_name&quot;

Page 424: Correction To Set Transaction Isolation Level Samples
On page 424, in the code sample,

Change:

&quot;USE Pubs SET TRANSACTION ISOLATION LEVEL READ COMMITTED&quot;

To:

&quot;USE Pubs SET TRANSACTION ISOLATION LEVEL SERIALIZABLE&quot;

Change:

&quot;USE Pubs SET TRANSACTION ISOLATION LEVEL READ COMMITTED&quot;

To:

&quot;USE Pubs GO SET TRANSACTION ISOLATION LEVEL REPEATABLE READ GO DBCC USEROPTIONS GO&quot;

Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections.

Additional query words: 0-7356-1960-3

Keywords: kbdocfix kbdocerr KB823320

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.