<docbook><section><title>SQLConfigXASupport</title><para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2">Configuring Microsoft SQL Server for XA support </bridgehead>
<para>XA support was tested against the following Microsoft SQL Server versions:</para><itemizedlist mark="bullet" spacing="compact"><listitem> MSSQL 6.5 RTM (WinNt4 Sp3)</listitem>
</itemizedlist><itemizedlist mark="bullet" spacing="compact"><listitem> MSSQL 7.0EE SP4 (Win2k AdvSrv Sp3)</listitem>
</itemizedlist><itemizedlist mark="bullet" spacing="compact"><listitem> MSSQL 2000 SP3a (Win2k Sp3)</listitem>
</itemizedlist><para>Before using the Microsoft SQL Server XA features, you must install and register the Microsoft SQL Server extended stored procedures, for this :</para><para>1) copy xp_oplxa.dll ( xp_oplxa65.dll for MSSQL 6.5) to the MSSQLServer_Root/binn directory</para><para>2) execute the command :</para><programlisting>isql.exe -Usa -Psa_pwd -ig:xp_oplxa.sql
</programlisting><para> or</para><programlisting>isql.exe -Usa -Psa_pwd -ig:xp_oplxa65.sql (for MSSQL 6.5)
</programlisting></section></docbook>