The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
| Version |
Location |
Description |
Submitted by |
Date submitted |
| Printed |
Page 41
6 lines from the bottom of page |
The word ALL should be included in the syntax expression for clarity:
The syntax of the ALL operator is:
<scalar_expression> { = | < > | ! = | > | > = | ! > | < | < = | ! < }
{ ALL | SOME | ANY} ( subquery )
|
Anonymous |
|
| Printed |
Page 118
Ch 5.6.1 Steps 4-7 |
I use InformIt Safari Online Books; so, I copied and pasted all of the code for this
example (I usually retype it, but I'd noticed no misprints in the book so far, so I
thought I was okay...:-(
Everything compiled and worked great until STEP 7, when SQL Server 2005 gave me the
following error: (sorry I don't have any more time to devote to helping you find the
error, but I suspect it's in the CLR code, since that's the part I paid the least
attention to on this)
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
Msg 6549, Level 16, State 1, Procedure VolumeInsertTrigger, Line 1
A .NET Framework error occurred during execution of user defined routine or aggregate
'VolumeInsertTrigger':
System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution
of user defined routine or aggregate 'VolumeUpdateTrigger':
.
.
System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution
of user defined routine or aggregate 'VolumeUpdateTrigger':
System.Data.SqlClient....
The statement has been terminated.
|
Anonymous |
|
| Printed |
Page 410
Within Main routine |
I had to change the line
nsi.RegisterLocal(serviceUserName, servicePassword);
to
nsi.RegisterLocal();
to avoid an SmoException
........ Lines deleted from execution trace........
Added application.
Unhandled Exception: Microsoft.SqlServer.Management.Smo.SmoException: The
Notification Services operation performed is invalid. --->
System.Reflection.TargetInvocationException:
Exception has been thrown by the target of an invocation. --->
The Notification Services Windows service could not be registered with the Service
Control Manager (SCM).
--- End of inner exception stack trace ---
|
Anonymous |
|