Create sql assembly from global dll

Question

Create sql assembly from global dll

ankur.bhargava

Mr or Mrs. 500

Points: 561
More actions
July 16, 2008 at 8:32 am

#184882

Hi,
I have created clr stored procedure from a dll, which is referencing a shared dll. When I am modifying the shared dll, I have to recompile the procedure dll. Is there any way by which I need not to compile the clr procedure dll? Here are the details what I am doing
1) I have created a dll named TED.
2) In TED dll I am referencing the TDC dll, which is, shared dll.
3) Modify the TDC dll, recompile it and deploy it in GAC with publisher policy.
4) Desktop applications are able to reference it successfully without any need to recompile them.
5) But I am receiving version error while creating sql assembly from TED dll and when I recompile the TED dll with latest reference of TDC dll it works.
Please suggest the way by which I don't need to recompile TED dll every time.
Ankur Bhargava

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

Generally, you would have issued a CREATE ASSEMBLY for your referenced assembly as well in SQL Server. If you do an auto deploy from VS 2005 it may have done this for you. Look in the sys.assemblies DMV and see if it is listed there.