SQL SERVER 2005 Create Assembly
Posted on 2010-09-21
I am trying to create an assembly in sql server 2005 so that I can use the functions inside the dll, This dll is working in production.
This is what I did and I got the following results after executing, Any inputs will be appreciated
CREATE ASSEMBLY [Charge]
WITH PERMISSION_SET = UNSAFE
Warning: The Microsoft .Net frameworks assembly 'system.xml.linq, version=22.214.171.124, culture=neutral, publickeytoken=b77a5c561934e089, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
Warning: The Microsoft .Net frameworks assembly 'system.core, version=126.96.36.199, culture=neutral, publickeytoken=b77a5c561934e089, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
Msg 10301, Level 16, State 1, Line 1
Assembly 'Charge' references assembly 'system.runtime.serialization, version=188.8.131.52, 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.