Previous Thread:   CLR DML Trigger Question

3/10/2006 3:58:40 PM    Deploying CLR Executables to Production Servers



3/11/2006 11:35:49 PM    Re: Deploying CLR Executables to Production Servers
Hello William,  
  
A couple of potential security/IP related things:  
  
a. By default and recommendation of MS, Visual Studio also catalogs the source  
  
code for the cataloged assemblies. Ick, you can get somebodies raw IP just  
  
by doing:  
  
select cast(content as xml) from sys.assembly_files where name like '%.cs'  
  
b. If even you don't deploy the source code, decompiling .NET isn't hard,  
  
and either is sucking the bits out of sys.assembly_files. See [0].  
  
[0]: http://www.sqljunkies.com/WebLog/ktegels/archive/2006/03/06/18506.aspx  
  
Thank you,  
  
Kent Tegels  
  
DevelopMentor  
  
http://staff.develop.com/ktegels/