You must have the following in place before using the SQL CLR Integration feature:
- SQL CLR Integration Enabled
- You must enable the SQL CLR feature in SQL Server. You can do this either from SQL Server Management Studio or as a batch process using
sqlcmd. The required commands are:
sp_configure 'clr enabled', 1
followed by
reconfigure
- Create a SQL CLR-enabled Data Source
- You must have a SQL CLR-enabled SQL Server data source to which you can connect.