Inside SQL Server 2000 Comment and Corrections (283895)

SUMMARY

This article contains comments, corrections, and information about known errors relating to the Microsoft Press book Inside Microsoft SQL Server 2000, ISBN 0-7356-0998-5.

The following topics are covered:

CD-ROM: Update Required For SQL Server 2000 Evaluation
Page 319: Incorrect Reference To Appendix D
Page 356: Code Lines Repeated
Page 365: Incorrect Syntax in Table 7-5

MORE INFORMATION

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 319: Incorrect Reference To Appendix D

On page 319, the Note section makes a reference to Appendix D. There is no Appendix D.

Change:
"...please see Appendix D for suggestions on further reading..."

To:
"...please see Bibliography and Suggested Reading on page 987 for suggestions on further reading..."

Page 356: Code Lines Repeated

On page 356, in the query, 13 lines from the page top, two lines of code are repeated. Delete the first instance of the following two lines:

WHERE NOT EXISTS
           (SELECT * FROM titles T1

Page 365: Incorrect Syntax in Table 7-5

On page 365, in Table 7-5, the first three entries should not contain question marks.

Change:

LIKE  'Mc?%'
LIKE '?%inger'
LIKE '?%en?%'

To:

LIKE 'Mc%'
LIKE '%inger'
LIKE '%en%'

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.