Skip to content

Instantly share code, notes, and snippets.

@jadiagaurang

jadiagaurang/To-add-Assembly-to-MSSQL.sql

Last active May 1, 2022 17:52
Show Gist options
  • Save jadiagaurang/c9b443bfd09857e6f05b626706f796cf to your computer and use it in GitHub Desktop.
Save jadiagaurang/c9b443bfd09857e6f05b626706f796cf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
To-add-Assembly-to-MSSQL.sql
--To Add Assembly to MSSQL
EXEC sp_configure 'clr strict security'; --Check Current Config
--Enable
EXEC sp_configure 'clr strict security', 1;
RECONFIGURE;
--Disable
EXEC sp_configure 'clr strict security', 0;
RECONFIGURE;
--To Allow Assembly to Execute
EXEC sp_configure 'clr enabled'; --Check Current Config
--Enable
EXEC sp_configure 'clr enabled' , 1;
RECONFIGURE;
--Disable
EXEC sp_configure 'clr enabled' , 0;
RECONFIGURE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment