Install the CLR Stored Procedure

You can use Studio to generate the files you require to install the CLR Stored Procedure. Studio contains a Stored Procedure Host item that enables you to specify default properties and then generate an installation package.

To install CLR Stored Procedure

1. Generate an install script package.

   The installation package is a .zip file that contains:

   • InstallScriptV200806.sql with default parameters

   • Citect.Ampla.Public.MSSQL.V200806.dll

   • Citect.Ampla.Public.MSSQL.V200806.XmlSerializers.dll

2. Register the script files in SQL Server.

Related topics

• CLR Stored Procedure

• Add and configure a CLR Stored Procedure Host connection