DBA > Job Interview Questions > Microsoft SQL Server FAQs

You then write a function to use this assembly,

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You then write a function to use this assembly, but it does not work. What could be the problem?

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?

Answer
The CLR environment needs to be enabled.

Explanation
By default on SQL Server 2005, the CLR runtime environment, which is what executes the .NET assemblies, is not enabled. You need to execute the following code to enable it:

(Continued on next question...)

Other Job Interview Questions