5 Appendix A: Product Behavior

  • Article

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 7.0

  • Microsoft SQL Server 7.0.533

  • Microsoft SQL Server 7.0.115

  • Microsoft SQL Server 7.5

  • Microsoft SQL Server 2000

  • 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: The storage subcontainer is implemented as a substorage in versions of the DTS package file format that are prior to SQL Server 7.0.533 (using the dwVersionMajor, dwVersionMinor, and dwVersionBuild fields in the version directory). The subcontainer is persisted using a substream that is named according to the same convention that was used for substorages in prior versions of Microsoft SQL Server.

<2> Section 2.3.1: In the Microsoft implementation, substorages of a package are encrypted by using Windows CryptoAPI version 1.0.

<3> Section 2.5.1: In the Microsoft implementation, the application log is the Windows "Application" log.

<4> Section 2.5.1: This property was added in SQL Server 7.0.533.

<5> Section 2.5.1: This property was added in SQL Server 7.0.533.

<6> Section 2.5.1: This property was added in SQL Server 7.0.533.

<7> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.544.

<8> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.544.

<9> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.544.

<10> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.544.

<11> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.544.

<12> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.80.

<13> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.80.

<14> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.80.

<15> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.80.

<16> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.80.

<17> Section 2.5.1: Only defined values specify that Windows Authentication is used to log in to the log server.

<18> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.80.

<19> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.80.

<20> Section 2.5.1: This property was added in Microsoft SQL Server 7.0.80.

<21> Section 2.5.1: This option is the default for SQL Server.

<22> Section 2.5.1: In the Microsoft implementation, this is Windows NT Integrated Security.

<23> Section 2.5.3.1.3: In the Microsoft implementation, the UseTrustedConnection property specifies whether to use Windows Authentication security mode.

If TRUE, Windows Authentication security mode is used.

If FALSE, Windows Authentication security mode is not used.

<24> Section 2.5.3.1.8: In the Microsoft implementation, the SourceTrustedLogin property specifies whether to use Windows Authentication for connection to the source.

If TRUE, Windows Authentication is used for connection to the source.

If FALSE, Windows Authentication is not used for connection to the source.

<25> Section 2.5.3.1.8: In the Microsoft implementation, the DestinationTrustedLogin property specifies whether to use Windows Authentication for connection to the destination.

If TRUE, Windows Authentication is used for connection to the destination.

If FALSE, Windows Connection is used for connection to the destination.

<26> Section 2.5.3.1.8: In the Microsoft implementation, this value indicates to include the SID for standard logins to SQL Server.

<27> Section 2.5.3.1.8: In the Microsoft implementation, this value indicates that script collation clauses are not used from a SQL Server 7.0.x source.

<28> Section 2.5.3.1.8: In the Microsoft implementation, this value indicates that features in SQL Server 7.0 are not used.

<29> Section 2.5.3.1.9: In the Microsoft implementation, the IsNTService property indicates whether a Windows NT Service is used.

If TRUE, email is sent from a Windows NT Service.

If FALSE, email is not sent from a Windows NT Service.

<30> Section 2.5.3.2.3: The UseTrustedConnection property specifies whether to use Windows Authentication.

If TRUE, Windows Authentication is used.

If FALSE, Windows Authentication is not used.

<31> Section 2.5.3.2.3: This property was added in Microsoft SQL Server 7.0.554.

<32> Section 2.5.8: In the Microsoft implementation, the UseTrustedConnection property specifies whether to use Windows Authentication security mode.

If TRUE, Windows Authentication is used.

If FALSE, Windows Authentication is not used.