Previous Thread:   CLR Accumulator

3/7/2006 10:40:20 AM    SQL CLR DLL's: Best Practice Location
Has Microsoft put out a "best practice" on where to locate DLL's for SQL  
  
CLR?  
  
I know that generally the old extended stored procedures DLL's would be  
  
generally placed in the BINN folder. Is this happening for SQL CLR files?  
  
My main concern is as an application developer producing CLR DLL's for a  
  
customer base. I want to make sure that the DLL's I distribute are unique to  
  
that SQL Server and will not be walked over by other applications or  
  
Microsoft.



3/7/2006 4:25:10 PM    Re: SQL CLR DLL's: Best Practice Location
Hello Chuck,  
  
Yes, there's exactly one choice. In the database. Nice and simple. :)  
  
Nope.  
  
That won't be a problem because when you catalog the assembly into the database,  
  
it simply copies it into internal storage for that database and that's that,  
  
see [0]. There's a bit on that in my blog from today [1] because there's  
  
a security consideration that you need to keep in mind of it.  
  
[0]: http://msdn2.microsoft.com/en-us/library/ms345106(sql.90).aspx  
  
[1]: http://www.sqljunkies.com/WebLog/ktegels/archive/2006/03/06/18506.aspx  
  
Thank you,  
  
Kent Tegels  
  
DevelopMentor  
  
http://staff.develop.com/ktegels/