Microsoft KB Archive/826872

= MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228, Second Edition Comments and Corrections =

Article ID: 826872

Article Last Modified on 3/1/2007

-

APPLIES TO


 * MSPRESS MCSA/MCSE/MCDBA Self-Paced Training Kit Microsoft SQL Server 2000 System Administration 2nd Edition, ISBN 0-7356-1961-1

-



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228, Second Edition, ISBN 0-7356-1961-1.

The following topics are covered:
 * Page xxxv: Correction To Setup Instructions
 * Page 99: SELECT @@SERVER-NAME Should Be SELECT @@SERVERNAME
 * Page 345: Create Should Be Drop
 * Pages 366 & 367: Corrections To Steps 18 And 35
 * Page 674: Correction To Answer A For 70-228.01.01.004
 * Page 831: sp_revokelogin Should Be sp_droplogin



Page xxxv: Correction To Setup Instructions
On page xxxv, under &quot;Setup Instructions&quot;,

Change:

&quot;5. Execute the setup.exe file in the \Setup folder of the CD-ROM. This will copy the exercise files that you will need to complete the hands-on procedures in this book.&quot;

To:

&quot;5. Copy the \SelfPacedSQL folder on the CD to C:\ drive. This will copy the exercise files that you will need to complete the hands-on procedures in this book.&quot;

On page 99: SELECT @@SERVER-NAME Should Be SELECT @@SERVERNAME
On page 99, in step 14,

Change:

&quot;SELECT @@SERVER-NAME&quot;

To:

&quot;SELECT @@SERVERNAME&quot;

Page 345: Create Should Be Drop
On page 345, in Table 10-9, in the Description field for Sp_droprole 'role',

Change:

&quot;Members of the sysadmin server role db_securityadmin and the db_owner fixed database roles can create user-defined database roles.&quot;

To:

&quot;Members of the sysadmin server role db_securityadmin and the db_owner fixed database roles can drop user-defined database roles.&quot;

Pages 366 & 367: Corrections To Steps 18 And 35
On page 366 in step 18, and on page 367 in step 35, there should be a space rather than a dot between &quot;TABLE&quot; and &quot;dbo&quot;.

Change:

&quot;CREATE TABLE.dbo.TestTable1&quot;

&quot;CREATE TABLE.dbo.TestTable2&quot;

To:

&quot;CREATE TABLE dbo.TestTable1&quot;

&quot;CREATE TABLE dbo.TestTable2&quot;

Page 674: Correction To Answer A For 70-228.01.01.004
On page 674, in answer A's explanation under 70-228.01.01.004, please remove:

&quot;it requires that you reinstall SQL Server&quot;

Page 831: sp_revokelogin Should Be sp_droplogin
On page 831, in the second paragraph,

Change:

&quot;...or by using sp_addlogin and sp_revokelogin.&quot;

To:

&quot;...or by using sp_addlogin and sp_droplogin.&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-1961-1

Keywords: kbdocfix kbdocerr KB826872

-

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

© Microsoft Corporation. All rights reserved.