MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server™ 2000 System Administration, Exam 70-228

Errata for MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server™ 2000 System Administration, Exam 70-228




The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
Printed
Page On page 99

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

Microsoft Press  Jul 13, 2010 
Printed
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."

Microsoft Press  May 06, 2010 
Printed
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."

Microsoft Press  May 06, 2010 
Printed
Page 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"

Microsoft Press  Jul 13, 2010 
Printed
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"

Microsoft Press  May 06, 2010 
Printed
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.

Microsoft Press  Jul 13, 2010