Missing Update KB971780

AK54808.MissingUpdateKB971780 (UnitMonitor)

Missing SQLServer update KB971780 can lead to incorrect queries.

Knowledge Base article:

External

http://go.microsoft.com/fwlink/?LinkId=199715

Element properties:

Target

Microsoft.KnowledgeServices.SQLServer.DBEngine

Parent Monitor

System.Health.ConfigurationState

Category

ConfigurationHealth

Enabled

True

Alert Generate

True

Alert Severity

Error

Alert Priority

High

Alert Auto Resolve

True

Monitor Type

Microsoft.KnowledgeServices.Library.ScheduledOleDBMonitor

Remotable

True

Accessibility

Public

Alert Message

SQL Server missing update KB971780 to prevent incorrect results problem

<Details>
<Content>You are missing SQL Server update KB971780. You might be susceptible to an incorrect results problem in SQL Server when using queries with LIKE clauses. The current SQL Server build for this instance of SQL Server does not have the fix for this problem. The probability of you encountering the problem is higher in databases or columns created with a collation version of 90 or 100.</Content>
<CollectedInformation>
<Info>
<Name>SQL Server version</Name>
<Value>{0}</Value>
</Info>
<Info>
<Name>Databases with collation version 90 or 100 (if any)</Name>
<Value>{1}</Value>
</Info>
</CollectedInformation>
</Details>

RunAs

Default

Comment

SupportTopic=Administration\Other;VersionNumber=1.0.0.5;

Source Code:

<UnitMonitor ID="AK54808.MissingUpdateKB971780" Comment="SupportTopic=Administration\Other;VersionNumber=1.0.0.5;" Accessibility="Public" Enabled="true" Target="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine" ParentMonitorID="Health!System.Health.ConfigurationState" Remotable="true" Priority="Normal" TypeID="KnowledgeServicesLibrary!Microsoft.KnowledgeServices.Library.ScheduledOleDBMonitor" ConfirmDelivery="true">

  <Category>ConfigurationHealth</Category>

  <AlertSettings AlertMessage="AK54808.MissingUpdateKB971780.AlertDisplayString">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>High</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/ProductVersion$</AlertParameter1>

      <AlertParameter2>$Data/Context/Columns/Column[1]$</AlertParameter2>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Success" MonitorTypeStateID="Success" HealthState="Success"/>

    <OperationalState ID="Error" MonitorTypeStateID="Error" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <ConnectionString>Provider=SQLOLEDB;Data Source=$Target/Property[Type="MicrosoftSQLServerLibrary!Microsoft.SQLServer.DBEngine"]/ConnectionString$;Initial Catalog=master;Integrated Security=SSPI</ConnectionString>

    <Query>select CAST((select name , collation_name from sys.databases where COLLATIONPROPERTY(collation_name,'Version') in ( 2 , 1 ) FOR XML PATH) as nvarchar(4000)) as Data</Query>

    <ErrorExpression>

      <And>

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/MajorVersion$</Value>

                </ValueExpression>

                <Operator>GreaterEqual</Operator>

                <ValueExpression>

                  <Value Type="Integer">10</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/MajorVersion$</Value>

                </ValueExpression>

                <Operator>Less</Operator>

                <ValueExpression>

                  <Value Type="Integer">11</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/MinorVersion$</Value>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="Integer">0</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

        <Expression>

          <Or>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/BuildNumber$</Value>

                </ValueExpression>

                <Operator>Less</Operator>

                <ValueExpression>

                  <Value Type="Integer">1812</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <And>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/BuildNumber$</Value>

                    </ValueExpression>

                    <Operator>GreaterEqual</Operator>

                    <ValueExpression>

                      <Value Type="Integer">2531</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/BuildNumber$</Value>

                    </ValueExpression>

                    <Operator>Less</Operator>

                    <ValueExpression>

                      <Value Type="Integer">2734</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

              </And>

            </Expression>

          </Or>

        </Expression>

      </And>

    </ErrorExpression>

    <SuccessExpression>

      <Not>

        <Expression>

          <And>

            <Expression>

              <And>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/MajorVersion$</Value>

                    </ValueExpression>

                    <Operator>GreaterEqual</Operator>

                    <ValueExpression>

                      <Value Type="Integer">10</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/MajorVersion$</Value>

                    </ValueExpression>

                    <Operator>Less</Operator>

                    <ValueExpression>

                      <Value Type="Integer">11</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/MinorVersion$</Value>

                    </ValueExpression>

                    <Operator>Equal</Operator>

                    <ValueExpression>

                      <Value Type="Integer">0</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

              </And>

            </Expression>

            <Expression>

              <Or>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/BuildNumber$</Value>

                    </ValueExpression>

                    <Operator>Less</Operator>

                    <ValueExpression>

                      <Value Type="Integer">1812</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

                <Expression>

                  <And>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/BuildNumber$</Value>

                        </ValueExpression>

                        <Operator>GreaterEqual</Operator>

                        <ValueExpression>

                          <Value Type="Integer">2531</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <Value Type="Integer">$Target/Property[Type="KnowledgeServicesSQLServerLibrary!Microsoft.KnowledgeServices.SQLServer.DBEngine"]/BuildNumber$</Value>

                        </ValueExpression>

                        <Operator>Less</Operator>

                        <ValueExpression>

                          <Value Type="Integer">2734</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                  </And>

                </Expression>

              </Or>

            </Expression>

          </And>

        </Expression>

      </Not>

    </SuccessExpression>

  </Configuration>

</UnitMonitor>