Combined Errata
Page 187
Exercise 5.5 (change 5.5 step 1 to the following:5.5 Step 1: Log in to Windows as Administrator and then open the Query Analyzer and log in using Windows Authentication.
Page 193
Exercise 5.8 (pg 193) step 10, Remove the word Sales from the step.
Page 220
Ex 5.22, step 7 ? change ?Capture to Table?- to ?Save to Table?
Page 287
NO_RECOVERY should be NORECOVERY. Fix this for all instances of NO_RECOVERY throughout this chapter.
Page 288
Tip ? It should read: ... issue the command RESTORE DATABASE database WITH RECOVERY to activate...
Page 302
Question19. Should be Answer B.
Page 331
End of step 5 should say ...displayed in Figure 7.4.
Page 362
Exercise 8.1 Step 6 ? should be pubs_full_backup not pubs_back.Â
Page 427
Author's note - step 10, If you wish to use a named instance, then use MSSQL$InstanceName\Data.
Page 436
step 15 - If your name did not change automatically, please do so manually.
Page 446
Step 1 - If snapshot replication did not start on it's own, right-click the agent and start it manually.
Page 475
Step 4 - add: ....IO displays disk time. Click OK when you are finished.
Page 480
Step 9 - note: this code will be used again in Step 16.
Page 481
step 16 - see detailed description
Step 16 should read in the code sample:
USE northwind
SELECT ......
|
Add to Cart
