Errata

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

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"

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.

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

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

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"