Microsoft KB Archive/309146

= Academic Learning Series Microsoft SQL Server 2000 System Administration Comments And Corrections =

Article ID: 309146

Article Last Modified on 3/1/2007

-

APPLIES TO


 * MSPRESS Academic Learning Series Microsoft SQL Server 2000 System Administration ISBN 0-7356-1426-1

-



This article was previously published under Q309146



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book Academic Learning Series Microsoft SQL Server 2000 System Administration, ISBN 0-7356-1426-1.

The following topics are covered:


 * CD-ROM: Update Required For SQL Server 2000 Evaluation
 * CD-ROM: Updated Script Files To Accommodate 25 Users
 * CD-ROM: Corrections To Number Of Users In LabSetup.doc
 * Lab Manual, Page 1: Correction To Number Of Users
 * Page 56: Corrections To Steps 25 And 26
 * Page 139: &quot;GET DATE&quot; Should Be &quot;GETDATE&quot;
 * Page 163: Incorrect System Function



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:



CD-ROM: Updated Script Files To Accommodate 25 Users
On the Instructor CD, the setup script files are designed to accommodate a class of 12 students. We have made available updated script files that will accommodate a class of 25 students.

These updated script files are available in the self-extracting executable file 25script.exe. After downloading the file, double-click on 25script.exe, extract the files into the /Setup folder on your computer, and allow the extracted files to overwrite existing files of the same file names.

The following file is available for download from the Microsoft Download Center:

25script.exe

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

CD-ROM: Corrections To Number Of Users In LabSetup.doc
On the Instructor CD, in the file LabSetup.doc,

On page 11,

Change:

&quot;Important The Add_Users.vbs script should have created the SQLServerUsers Organizational Unit (OU). In this OU, 36 user accounts should have been created, AccountingUser01 through AccountingUser12, Student01 through Student12, and TestUser01 through TestUser12. In this OU, 3 security groups should have been created, Accounting, SQL Admins and SQL Users. The SQL Users security group should contain all 36 user accounts. The SQL Admins security group should contain user accounts Student01 through Student12. The Accounting security group should contain user accounts AccountingUser01 through AccountingUser12.&quot;

To:

&quot;Important The Add_Users.vbs script should have created the SQLServerUsers Organizational Unit (OU). In this OU, 72 user accounts should have been created, AccountingUser01 through AccountingUser25, Student01 through Student25, and TestUser01 through TestUser25. In this OU, 3 security groups should have been created, Accounting, SQL Admins and SQL Users. The SQL Users security group should contain all 72 user accounts. The SQL Admins security group should contain user accounts Student01 through Student25. The Accounting security group should contain user accounts AccountingUser01 through AccountingUser25.&quot;

On page 14, in Step 10,

Change:

&quot;10. In the Name column, click AccountingUser01, scroll to the end of the list of names, and then press the Shift key and click TestUser12. The 36 users in the SQLServerUsers OU are selected.&quot;

To:

&quot;10. In the Name column, click AccountingUser01, scroll to the end of the list of names, and then press the Shift key and click TestUser25. The 72 users in the SQLServerUsers OU are selected.&quot;

On page 17, in step 16,

Change:

&quot;16. Repeats steps 9 - 12 above for each student account (Student01 - Student12).&quot;

To:

16. Repeat steps 9 - 12 above for each student account (Student01 - Student25).

Lab Manual, Page 1: Correction To Number Of Users
In the Lab Manual, on page 1, under &quot;Before You Begin&quot;,

Change:

&quot;Each student computer is named Serverxx, where xx is a two-digit number between 01 and 12.&quot;

To:

&quot;Each student computer is named Serverxx, where xx is a two-digit number between 01 and 25.&quot;

Page 56: Corrections To Steps 25 And 26
On page 56, change:

&quot;25. Click Start and then click Run.

The Open dialog box appears.

26. In the Open drop-down combo box, type...&quot;

To:

&quot;25. Click Start, point to Accessories, then click Command Prompt.

The Command Prompt window appears.

26. At the command prompt, type...&quot;

Page 139: &quot;GET DATE&quot; Should Be &quot;GETDATE&quot;
On page 139, in Table 5.4, the system function &quot;GETDATE&quot; should be one word, with no space in it.

Change:

&quot;GET DATE&quot;

To:

&quot;GETDATE&quot;

Page 163: Incorrect System Function
On page 163, in the first paragraph, change:

&quot;DATAPROPERTYEX&quot;

To:

&quot;DATABASEPROPERTYEX&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: ALS 0-7356-1426-1 RABELER

Keywords: kbdownload kbdocerr kbdocfix kbinfo KB309146

-

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

© Microsoft Corporation. All rights reserved.