DOCUMENT:Q235214 06-MAR-2001 [mspress] TITLE :Microsoft SQL Server 7.0 System Administration Training Kit Comm PRODUCT :Microsoft Press PROD/VER:: OPER/SYS: KEYWORDS:kbdocfix kbdocerr ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - MSPRESS Microsoft SQL Server 7.0 System Administration Training Kit ISBN 1-57231-827-9 ------------------------------------------------------------------------------- SUMMARY ======= This article contains comments, corrections, and information about known errors relating to the Microsoft Press book Microsoft SQL Server 7.0 System Administration Training Kit, ISBN 1-57231-827-9. The following topics are covered: - CD-ROM: Correction To Runbcpa.cmd File (Chapter 6) - Page xxx: Corrections For Installing StudyNwind Database - Page 118: Change Drop to Remove - Page 126: Connection Between RAID Level And Fault Tolerance Incorrect - Page 162: Step 42 Incorrectly Duplicates Step 38 - Page 302: Sp_addrolemember Example Incorrect - Page 354, Exercise 4: Steps 2 Through 5 Are Incorrect - Page 474: Incorrect statement for step 8 MORE INFORMATION ================ CD-ROM: Correction To Runbcpa.cmd File (Chapter 6) -------------------------------------------------- Page 143 walks you through the steps to import data using the bcp utility. If you choose to use the completed batch file for this exercise, instead of creating your own, a typo in the Runcpa.cmd file (C:\Sqladmin\Exercise\Ch06\Runcpa.cmd) needs to be corrected. The space between "/e" and "C:\Sqladmin..." was omitted. Change: bcp StudyNwind..Products in c:\sqladmin\exercise\ch06\newprods.txt /c /t"," /r\n /ec:\sqladmin\exercise\ch06\newprods.err /b250 /m50 /SSQLSERVER /Usa To: bcp StudyNwind..Products in c:\sqladmin\exercise\ch06\newprods.txt /c /t"," /r\n /e c:\sqladmin\exercise\ch06\newprods.err /b250 /m50 /SSQLSERVER /Usa Please remember that this command should contain no hard returns and that "/SSQLSERVER" should be replaced with your server name if your server name is not SSQLSERVER. Page xxx: Corrections For Installing StudyNwind Database -------------------------------------------------------- On page xxx, the instructions for using the StudyNwind Database do not mention that you must have SQL already installed on your computer to run the batch file. In fact, the previous page, xix, indicates that you will not install SQL Server until Chapter 2. Note: You must install SQL Server before running the batch file as outlined in the instructions in the section titled "Using the StudyNwind Database". Page 118: Change Drop to Remove ------------------------------- On page 118, under "Using Automatic File Growth" section, in lines 4 and 6 of the altering database syntax example, change DROP to REMOVE. Change: "| DROP FILE logical_file" "| DROP FILEGROUP filegroup" To: "| REMOVE FILE logical_file" "| REMOVE FILEGROUP filegroup" Page 126: Connection Between RAID Level And Fault Tolerance Incorrect --------------------------------------------------------------------- On page 126, in the "Leveraging Windows NT Server Fault Tolerance" section, the information about the RAID level and its corresponding fault tolerance is incorrect. Change: "The levels are ranked numerically according to their ability to provide fault tolerance. RAID 0 provides no fault tolerance, whereas RAID 5 provides the best fault tolerance." To: "RAID 0 provides no fault tolerance, whereas RAID 1 provides the best fault tolerance" Page 162: Step 42 Incorrectly Duplicates Step 38 ------------------------------------------------ On page 162, in the exercise titled "Creating a Package with DTS Designer," steps 38 and 42 are identical. Step 42 should read: "In the Source Step column, select Create ProductsCopy. In the Precedence column, select Success. Note that you cannot change the Destination Step, because you are editing the precedence constraints for Copy data from Access to SQL Server, which is the destination step. Click OK to close the Workflow Properties dialog box and save the precedence constraints for Copy data from Access to SQL Server." Page 302: Sp_addrolemember Example Incorrect -------------------------------------------- Page 302, fifth line down: Change: "sp_addrolemember 'Carl', 'db_datareader' " To: "sp_addrolemember 'db_datareader', 'Carl' " Page 354, Exercise 4: Steps 2 Through 5 Are Incorrect ----------------------------------------------------- On page 354, Exercise 4, replace steps 2 through 5 with the following steps: 2. In the console tree, right-click the server, click Properties. click the Server Settings tab, then click Change. 3. In the Profile Name drop-down list, select SQLServerAgent Profile. 4. Click Test. A message appears, indicating that the test was successful. Click OK to close the message. 5. Click OK to close the SQL Server Properties dialog box. A message appears asking you if you want to restart SQL Server Agent so that the changes you have made will take effect. Click Yes. Click OK when the service has restarted. Page 474: Incorrect statement for step 8 ---------------------------------------- On page 474, change the statement in step 8 to select from the ReplProducts table. Statement should read: USE PullSubs SELECT * FROM ReplProducts WHERE ProductID = 1 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: 1-57231-827-9 tkbook sql70 ====================================================================== Keywords : kbdocfix kbdocerr Technology : kbMSPressSearch Version : : Issue type : kbinfo ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2001.