Microsoft KB Archive/304910

= MCSE Training Kit Microsoft SQL Server 2000 Database Design and Implementation Comments And Corrections =

Article ID: 304910

Article Last Modified on 2/6/2003

-

APPLIES TO


 * MSPRESS MCSE Training Kit, Microsoft SQL Server™ 2000 Database Design and Implementation ISBN 0-7356-1248-x

-



This article was previously published under Q304910



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book MCSE Training Kit Microsoft SQL Server™ 2000 Database Design and Implementation, ISBN 0-7356-1248-X.

The following topics are covered:


 * CD-ROM: Update Required For SQL Server 2000 Evaluation
 * Page 30: Incorrect Caption For Figure 1.7
 * Page 64: &quot;customer&quot; Should Be &quot;customers&quot;
 * Page 72: &quot;Object Window&quot; Should Be &quot;Object Browser window&quot;
 * Page 73: &quot;sp_helpprotect&quot; Should Be &quot;sp_helprotect&quot;
 * Page 73: Missing Step
 * Page 87: ’a.' Should Be ’a’.
 * Page 93: &quot;sp_exectesql&quot; Should Be &quot;sp_executesql&quot;
 * Page 106, Figure 3.7: &quot;Authors&quot; Should Be &quot;BookAuthor&quot;
 * Page 108: Incomplete List
 * Page 108: &quot;users table&quot; Should Be &quot;user table&quot;
 * Page 110: Typo In Step 5
 * Page 135: Missing Title Column In The Column List For Table Books
 * Pages 137, 138, & 139: Typos In Figures 3.14, 3.15, & 3.16
 * Page 139: Typo In Figure 3.16
 * Page 199: Incorrect Table Name
 * Page 339: Incorrect CREATE TRIGGER Sample Statement
 * Page 406: Correction To FILLFACTOR Property
 * Page 435: Connections Should Be Transactions
 * Page 453: Incorrect Code Sample for DBCC USEROPTIONS
 * Page 471: Correction To Auditing



CD-ROM: Update Required For SQL Server 2000 Evaluation
The SQL Server 2000 Evaluation software packaged with this book must be updated to prevent susceptibility to the recently discovered Slammer virus. An update has been made available from Microsoft.

Immediately after installing the evaluation software, please download the appropriate update for your environment. The updates can be found at the following URL:



Further information on this virus and vulnerabilities to it can be found at:



Page 30: Incorrect Caption For Figure 1.7
On page 30, in the caption for Figure 1.7,

Change:

&quot;Figure 1.7 Relational engine components&quot;

To:

&quot;Figure 1.7 Relational database engine components&quot;

Page 64: &quot;customer&quot; Should Be &quot;customers&quot;
On page 64, under &quot;To correct a Transact-SQL statement &quot;, in step 1,

Change:

&quot;customer&quot;

To:

&quot;customers&quot;

Page 72: &quot;Object Window&quot; Should Be &quot;Object Browser window&quot;
On page 72, under &quot;To display information about a table&quot;,

Change:

&quot;4. Close the Object Window but leave the Query window open for the next procedure.&quot;

To:

&quot;4. Close the Object Browser window but leave the Query window open for the next procedure.&quot;

Page 73: &quot;sp_helpprotect&quot; Should Be &quot;sp_helprotect&quot;
On page 73, in step 3 under the first bulleted item,

Change:

&quot;EXEC sp_helpprotect Investors&quot;

To:

&quot;EXEC sp_helprotect Investors&quot;

Page 73: Missing Step
On page 73, under &quot;To revoke permissions on a database object&quot;, after the Hint in step 1,

Insert:

&quot;2. Highlight the REVOKE statement, then execute it.&quot;

Change numbering for steps 2 and 3: 2 to 3 and 3 to 4

Page 87: ’a.' Should Be ’a’.
On page 87, in step 2, inside comments after “INSERT INTO [New Table] VALUES”,

Change in two places:

’a.’

To:

’a’.

Page 93: &quot;sp_exectesql&quot; Should Be &quot;sp_executesql&quot;
On page 93, in Figure 2.12, inside the rectangle under “Batch execution plan”,

Change:

&quot;2. sp_exectesql N’ INSERT…’&quot;

To:

&quot;2. sp_executesql N’INSERT…’&quot;

Page 106, Figure 3.7: &quot;Authors&quot; Should Be &quot;BookAuthor&quot;
On page 106, in Figure 3.7, the third table's name,

Change:

&quot;Authors&quot;

To:

&quot;BookAuthors&quot;

Page 108: Incomplete List
On page 108, in the top paragraph,

Change:

&quot;The list includes users tables, system tables, stored procedures, functions, and user-defined data types.&quot;

To:

&quot;The list includes user tables, system tables, views, stored procedures, functions, and user-defined data types.&quot;

Page 108: Incomplete List
On page 108, in steps 5 and 4, &quot;users table&quot; should be &quot;user table&quot;.

Change:

&quot;Expand the Users Tables node.&quot;

To:

&quot;Expand the User Tables node.&quot;

Change:

&quot;A list of users tables in the Northwind database appears.&quot;

To:

&quot;A list of user tables in the Northwind database appears.&quot;

On page 108, under &quot;To view the contents of a table&quot;, in step 4,

Change:

&quot;Review each users table object to determine the columns in each one.&quot;

To:

&quot;Review each user table object to determine the columns in each one.&quot;

Page 110: Typo In Step 5
On page 110, in step 5,

Change:

&quot;5. Select the Add Selected Tables Automatically checkbox.&quot;

To:

&quot;5. Select the Add Related Tables Automatically checkbox.&quot;

Page 135: Missing Title Column In The Column List For Table Books
On page 135, in the Table – Columns table, change:

Table Columns:

TitleID, AuthorID, Publisher, PubDate, Edition, Cost, SRP, ConditionID, Sold

To:

Table Columns:

TitleID, Title, AuthorID, Publisher, PubDate, Edition, Cost, SRP, ConditionID, Sold

Pages 137, 138, & 139: Typos In Figures 3.14, 3.15, & 3.16
On pages 137, 138, & 139, in Figures 3.14, 3.15, & 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 139: Typo In Figure 3.16
On page 139, in Figure 3.16, change the table's name from:

&quot;BooksAuthors&quot;

To:

&quot;BookAuthors&quot;

Page 199: Incorrect Table Name
On page 199, in step 2 under the second bulleted item,

Change:

&quot;ALTER TABLE Customer&quot;

To:

&quot;ALTER TABLE Customers&quot;

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

&quot;CREATE TABLE trigger_name&quot;

To:

&quot;CREATE TRIGGER trigger_name&quot;

Page 406: Correction To FILLFACTOR Property
On page 406, in the last paragraph,

Change:

&quot;The FILLFACTOR keyword configures the index so that the leaf level index pages are 40 percent full, leaving 60 percent of the space to contain additional index key entries.&quot;

To:

&quot;The FILLFACTOR keyword configures the index so that the leaf level index pages are 60 percent full, leaving 40 percent of the space to contain additional index key entries.&quot;

Page 435: Connections Should Be Transactions
On page 435, in the first paragraph, change:

&quot;... and SQL Server rolls back any outstanding connections when the network notifies it of the break.&quot;

To:

&quot;... and SQL Server rolls back any outstanding transactions when the network notifies it of the break.&quot;

Page 453: Incorrect Code Sample for DBCC USEROPTIONS
On page 453, in the second instance of the code sample,

Change:

USE Pubs SET TRANSACTION ISOLATION LEVEL READ COMMITTED

To:

Use Pubs DBCC USEROPTIONS

Page 471: Correction To Auditing
On page 471, in the first paragraph under &quot;Auditing&quot;, remove the reference to xp_loginconfig extended stored procedure:

Change:

&quot;Login authentication success and failure is a server option that you configure with the xp_loginconfig extended stored procedure or by using the...&quot;

To:

&quot;Login authentication success and failure is a server option that you configure by using the...&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.

