SQL Server 2008 SQLCLR Issue
- by Joe Bloggs
I have a SQLCLR that was originally running on SQL Server 2005 DB. I have since rebuilt the CLR to run on SQL Server 2008. The CLR requires a reference to WindowsBase.dll. I added WindowsBase.dll as an assembly to the SQL Server 2008 DB. When I try to use the rebuilt CLR I get the message
Could not load file or assembly 'WindowsBase, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)
I tried to drop and recreate the WindowsBase assembly (making sure to use the dll from the GAC) but I still get the above error. Any suggestions on how to resolve this issue would be greatly appreciated.
Cheers