Where is the CLR dll?

[bigfoot]

I created a CLR in Visual Studio 2005 and deployed it to my sql server 2005 database.
Where IS the actual dll on the database server's drive.

I can't find an answer anywhere on msdn.

 

[gmmastros]

I think it's NOT stored on the hard drive. I think the contents of the DLL are stored in a table.

select * from sys.assemblies

select * from sys.assembly_files

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bigfoot]

Well that's interesting. Thank you!

That beggs another question then. When I compile the dll, where is the correct place to copy it to?

Do we set up a div-dev folder?

 

[gmmastros]

Here's an example of creating a CLR.

http://blogs.lessthandot.com/index....ming/sql-server-distance-calculation-option-3

I think it doesn't really matter where you put the dll. What I mean is....

CREATE ASSEMBLY DistanceCalculations FROM 'C:\YourDLLName.dll'

When you create the assembly, you need to identify where the dll is. That statement, I believe, will take the binary code of the dll, and copy it to the database. So, once the assembly is created, you don't need the DLL anymore.

I'm not as familiar with this stuff as I would like to be, but a friend of mine told me that you can create the assembly in one database, detach it, attach it to another server, and the CLR will still be there. I haven't tested this for myself.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bigfoot]

Thanks, George.

I'm using VS 2005 so that's what messed me up. I didn't have to create the assembly I think VS did it for me.

Sometimes it's better to learn the long way first.