Tutorial: Prepare the SQL CLR Stored Procedures Environment

Guides you through the process of creating the SQL CLR environment required for the SQL CLR Stored Procedures tutorials.

Prerequisite

Review the Assumptions and Before you begin a tutorial sections in the Tutorials: SQL CLR Stored Procedures Called via COBOL and JCL topic to ensure that your environment is set up properly.

Sequence

To complete this tutorial, progress through these topics in the order presented here. The bottom of each topic provides Next topic and Previous topic navigational links to help you proceed in the proper sequence:

  1. Enable SQL CLR Integration
    Takes you through the process of enabling the SQL CLR Integration feature in Microsoft SQL Server.
  2. Create the SQLCLR_Test Database
    Walks you through the process of creating the sample database required to complete these tutorials, and populate the database with the necessary data.
  3. Create an ODBC 32-bit System Connection
    Walks you through the process of creating an ODBC connection to use when completing these tutorials.
  4. Build the ODBC XA Switch Module
    Guides you through the process of configuring your machine to build the ODBC XA switch module used in these tutorials, and then building the module.
  5. Import 32-bit JCL Enterprise Server Regions
    Provides step-by-step instructions for importing the provided enterprise server regions required to complete these tutorials.
Parent topic: Tutorials: SQL CLR Stored Procedures Called via COBOL and JCL
Related concepts
Tutorials: SQL CLR Stored Procedures Called via COBOL and JCL