Errata

MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server™ 2000 Database Design and Implementation, Exam 70-229

Errata for MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server™ 2000 Database Design and Implementation, Exam 70-229

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
Printed
Page 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:"Authors"





To:



"BookCondition"







Change the table's name from:"BooksOrders"





To:



"BookOrders"







Change the column name in table OrderStatus from:



"StatusDescip"





To:



"StatusDescrip"

 Microsoft Press  Jul 13, 2010 
Printed
Page 424

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



Change:



"USE Pubs

SET TRANSACTION ISOLATION LEVEL READ COMMITTED"





To:



"USE Pubs

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE"





Change:



"USE Pubs

SET TRANSACTION ISOLATION LEVEL READ COMMITTED"



To:

"USE Pubs

GO

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

GO

DBCC USEROPTIONS

GO"

 Microsoft Press  Jul 13, 2010 
Printed
Page 72

"sp_helpprotect" Should Be "sp_helprotect" On page 72, in line 2 and line 18, Change: "EXEC sp_helpprotect Investors" To: "EXEC sp_helprotect Investors"

 Microsoft Press  May 06, 2010 
Printed
Page 320

Incorrect CREATE TRIGGER Sample Statement On page 320, under "Creating Triggers Using Transact-SQL",Change:"CREATE TABLE trigger_name"To:"CREATE TRIGGER trigger_name"

 Microsoft Press  May 06, 2010 
Printed
Page 474

"Query Analyzer" should be "SQL Query Analyzer" On page 474, Step 14 contains an incorrect application name. Change: "14. Expand the Like criteria and in the empty text box that appears, type Query Analyzer." To: "14. Expand the Like criteria and in the empty text box that appears, type SQL Query Analyzer." 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.

 Microsoft Press  May 06, 2010