CLR

Question 1

What are the permissions you can set in WITH PERMISSION_SET when creating an assembly?

Answer 1

SAFE
EXTERNAL_ACCESS
UNSAFE

Question 2

What is SAFE permission_set?

Answer 2

It is the most restrictive permission set. It cannot access the network, files, env variables or registry

Question 3

What is EXTERNAL_ACCESS permission_set?

Answer 3

Enables assemblies to access certain external system resources such as files, networks, env variables and registry

Question 4

What is UNSAFE permission_set?

Answer 4

Unrestricted access both within SQL instance and without. Very UNSAFE (Hence the name)

Question 5

What is the code to implement a .net framework assembly?

Answer 5

EXTERNAL NAME Assembly.Class.Method

Question 6

What is the syntax to use a DLL in SSMS (IE: CLR stored procedure)?

Answer 6

CREATE ASSEMBLY AssemblyName FROM N’C:\PATH\ASSEMBLY.DLL’ WITH PERMISSION_SET = [SAFE,UNSAFE,EXTERNAL_ACCESS]

Question 7

How do you enable the system to use CLR Integration?

Answer 7

EXEC sp_configure ‘clr enabled’, 1;

RECONFIGURE;