Errata for MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server™ 2000 Database Design and Implementation, Exam 70-229
Submit your own errata for this product.
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 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 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 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 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 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 |
|
|
| |
