I have installed visual studio 2008 and .net framework 3.5 in my computer. I have then created an assembly in 3.5, but when I try to create assembly in SQL Server 05, it keeps showing me error for Assembly 'ConsoleApplication1' references assembly 'system.xml.linq, version=126.96.36.199, culture=neutral, publickeytoken=b77a5c561934e089.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request. Now, I have no choice, but to manually include those 3.5 library in the same folder of the assembly. Is there anyway to work around it?