You have created a new assembly and want to test it on SQL Server 2005. You install the developer edition with defaults on your workstation and create the assembly as a sysadmin. You then write a function to use this assembly, but it does not work. What could be the problem?
A. .NET assemblies cannot be run on developer edition. You need to install Standard or Enterprise.
B. The CLR environment needs to be enabled.
C. You do not have the correct permissions to run a .NET assembly.
D. The assembly was not created with an explicit permission set assigned. You need to drop it and recreate it with SAFE, UNSAFE, or EXTERNAL_ACCESS explicitly set
Answer:B
You have created a new assembly and want to test it on SQL Server 2005. You install the developer edition with defaults on your workstation and create the assembly as a sysadmin. You then write a function to use this assembly, but it does not work. What could be the problem?
A. .NET assemblies cannot be run on developer edition. You need to install Standard or Enterprise. B. The CLR environment needs to be enabled. C. You do not have the correct permissions to run a .NET assembly. D. The assembly was not created with an explicit permission set assigned. You need to drop it and recreate it with SAFE, UNSAFE, or EXTERNAL_ACCESS explicitly set