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

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

MORE INFORMATION

Page xxxv: Correction To Setup Instructions

On page xxxv, under "Setup Instructions",

Change:
"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."

To:
"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."

On page 99: SELECT @@SERVER-NAME Should Be SELECT @@SERVERNAME

On page 99, in step 14,

Change:
"SELECT @@SERVER-NAME"

To:
"SELECT @@SERVERNAME"

Page 345: Create Should Be Drop

On page 345, in Table 10-9, in the Description field for Sp_droprole 'role',

Change:
"Members of the sysadmin server role db_securityadmin and the db_owner fixed database roles can create user-defined database roles."

To:
"Members of the sysadmin server role db_securityadmin and the db_owner fixed database roles can drop user-defined database roles."

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 "TABLE" and "dbo".

Change:
"CREATE TABLE.dbo.TestTable1"
"CREATE TABLE.dbo.TestTable2"

To:
"CREATE TABLE dbo.TestTable1"
"CREATE TABLE dbo.TestTable2"

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:

"it requires that you reinstall SQL Server"

Page 831: sp_revokelogin Should Be sp_droplogin

On page 831, in the second paragraph,

Change:
"...or by using sp_addlogin and sp_revokelogin."

To:
"...or by using sp_addlogin and sp_droplogin."

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.