Microsoft KB Archive/296793

= MCSE Training Kit Microsoft SQL Server 2000 System Administration Comments And Corrections =

Article ID: 296793

Article Last Modified on 3/1/2007

-

APPLIES TO


 * MSPRESS MCSE Training Kit, Microsoft SQL Server 2000 System Administration ISBN 0-7356-1247-1

-



This article was previously published under Q296793



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book MCSE Training Kit Microsoft SQL Server 2000 System Administration, ISBN 0-7356-1247-1.

The following topics are covered:


 * CD-ROM: Update Required For SQL Server 2000 Evaluation
 * Page 56: Corrections To Steps 25 And 26
 * Page 56: Correction To Path
 * Page 124: Correction To Uniform Extents Description
 * Page 139: &quot;GET DATE&quot; Should Be &quot;GETDATE&quot;
 * Page 140: SpacedUsed Should Be SpaceUsed
 * Page 156: Incorrect Log File Extension
 * Page 163: Incorrect System Function
 * Page 558: Publisher Should Be Distributor



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 56: Corrections To Steps 25 And 26
On page 56, change:

&quot;25. Click Start and then click Run.

The Open dialog box appears.

26. In the Open drop-down combo box, type...&quot;

To:

&quot;25. Click Start, point to Accessories, then click Command Prompt.

The Command Prompt window appears.

26. At the command prompt, type...&quot;

Page 56: Correction To Path
On page 56,

Change:

&quot;26. ... d:\x86\setup\setupsql.exe k=SMS -s -m -SMS -f1 'c:\winnt\setup.iss'.

27. Click OK.&quot;

To:

&quot;26. ... d:\sqleval\x86\setup\setupsql.exe k=SMS -s -m -SMS -f1 'c:\winnt\setup.iss'.

27. Press Enter.&quot;

Page 124: Correction To Uniform Extents Description
On page 124, in the first paragraph under &quot;Allocating Space for Tables and Indexes&quot;,

Change:

&quot;... and uses uniform extents to store, whereas SQL Server 2000 uses uniform extents to store data from a single object.&quot;

To:

&quot;... and uses uniform extents to store data from a single object.&quot;

Page 139: &quot;GET DATE&quot; Should Be &quot;GETDATE&quot;
On page 139, in Table 5.4, the system function &quot;GETDATE&quot; should be one word, with no space in it.

Change:

&quot;GET DATE&quot;

To:

&quot;GETDATE&quot;

Page 140: SpacedUsed Should Be SpaceUsed
On page 140, in step 7,

Change:

&quot;SpacedUsed&quot;

To:

&quot;SpaceUsed&quot;

Page 156: Incorrect Log File Extension
On page 156, in the code sample,

Change:

&quot;TSQLDB2.ledf&quot;

To:

&quot;TSQLDB2.ldf&quot;

Page 163: Incorrect System Function
On page 163, in the first paragraph, change:

&quot;DATAPROPERTYEX&quot;

To:

&quot;DATABASEPROPERTYEX&quot;

Page 558: Publisher Should Be Distributor
On page 558, in the first line,

Change:

&quot;By default, this agent runs at the Publisher, using the server resources of the Publisher.&quot;

To:

&quot;By default, this agent runs at the Distributor, using the resources of the Distributor.&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: TKBOOK 0-7356-1247-1 RABELER

Keywords: kbdocerr kbdocfix kbinfo KB296793

-

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

© Microsoft Corporation. All rights reserved.