7 Appendix B: Product Behavior

The information in this specification is applicable to the following Microsoft products or supplemental software. References to product versions include updates to those products.

Microsoft SQL Server 2005

Exceptions, if any, are noted in this section. If an update version, service pack or Knowledge Base (KB) number appears with a product name, the behavior changed in that update. The new behavior also applies to subsequent updates unless otherwise specified. If a product edition appears with the product version, behavior is different in that product edition.

Unless otherwise specified, any statement of optional behavior in this specification that is prescribed using the terms "SHOULD" or "SHOULD NOT" implies product behavior in accordance with the SHOULD or SHOULD NOT prescription. Unless otherwise specified, the term "MAY" implies that the product does not follow the prescription.

<1> Section 2.2.2.2.1.1.3: The possible values of the SqlMessage.Source attribute are listed in the following table.

Value	Meaning
Microsoft-SQL/9.0	This value is returned as part of SqlMessage.Source when the SqlMessage is generated by SQL Server 2005.

 

<2> Section 2.2.4.1.1: The supported values of this attribute are listed in the following table.

Value	Meaning
0	Microsoft SQL Server 2000 collation
1	SQL Server 2005 collation

 

<3> Section 2.2.5.1: The meanings for "BinarySort" and "BinarySort2" in sqlCompareOptionsEnum are listed in the following table.

Value	Meaning
BinarySort	Sorts and compares string data based on the bit patterns defined for each character that is compatible with SQL Server 2000 binary sorting.
BinarySort2	Sorts and compares string data based on code-point comparison semantics in SQL Server 2005.

<4> Section 3.1.3: For more information about establishing additional endpoints, see [MSDN-SSLNXWS].