Introduction

SQL Server and Azure SQL Managed Instance enable you to implement some of the functionalities with .NET languages using the native common language runtime (CLR) integration as SQL Server server-side modules (procedures, functions, and triggers). The CLR supplies managed code with services such as cross-language integration, code access security, object lifetime management, and debugging and profiling support.

For SQL Server users and application developers, CLR integration means that you can write stored procedures, triggers, user-defined types, user-defined functions (scalar and table valued), and user-defined aggregate functions using any .NET Framework language, including C# Visual Basic .NET. SQL Server includes the .NET Framework version 4 preinstalled.

Problem

Enable CLR

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_server_clr.sql

Example

Based on https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration/common-language-runtime-integration-overview?view=sql-server-ver16