title: MSSQL 2012 creating CLR triggers for WCF fails
body: <p>I've created system that uses CLR triggers to connect to WCF server and notify it about changes in DB.
  It runs ok on SQL server 2008 R2.
  Now im trying to migrate on SQL Server 2012.
  To use WCF i need to load SMDiagnostics.dll assembly along the others.
  Ive checked that clr is enabled in db , and set trustworthy to be "on", ive disabled WCF debuging, ive checked that SQL server runs under Local System account so there is no problems with permissions.
  Now my problem is that when i run following command</p>
  
  <pre><code>IF  NOT EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'SMdiagnostics')
  create assembly [SMdiagnostics]
  from  'C:\Windows\Microsoft.NET\Framework\v3.0\Windows Communication        Foundation\SMdiagnostics.dll'
  with permission_set = unsafe
  go
  </code></pre>
  
  <p>i receive following error </p>
  
  <blockquote>
    <p>Warning: The Microsoft .NET Framework assembly 'smdiagnostics,
    version=3.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089,
    processorarchitecture=msil.' you are registering is not fully tested
    in the SQL Server hosted environment and is not supported. In the
    future, if you upgrade or service this assembly or the .NET Framework,
    your CLR integration routine may stop working. Please refer SQL Server
    Books Online for more details. Msg 6586, Level 16, State 1, Line 2
    Assembly 'SMdiagnostics' could not be installed because existing
    policy would keep it from being used.</p>
  </blockquote>
  
  <p>SMdiagnostics.dll exists at specified path.
  As i understand its some kind of policy in SQL server 2012 or in GAC, however i cant find no policies about SMdiagnostics.
  Any ideas how to solve it?
  Thanks.</p>