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

MORE INFORMATION

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"

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:
"Authors"

To:
"BookCondition"

Change the table's name from:
"BooksOrders"

To:
"BookOrders"

Change the column name in table OrderStatus from:
"StatusDescip"

To:
"StatusDescrip"

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"

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 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.