CLR Function not working in restored database

Posted by Ben Thul on Stack Overflow See other posts from Stack Overflow or by Ben Thul
Published on 2011-01-08T17:50:06Z Indexed on 2011/01/08 17:54 UTC
Read the original article Hit count: 267

Filed under:

So I've restore a database with CLR assemblies in it from one physical server to another. One of the functions in the CLR assembly essentially does an uncompress of some compressed data. When I run this function against data in the restored database it returns the compressed data (rather than the uncompressed data). No error is thrown in SSMS or in the SQL server error logs. At the suggestion of others, I've checked differences in the database ownership (both owned by sa), trustworthiness (both set to not trustworthy). I also checked differences in the .NET framework installs on both machines but found only that the target machine had a 1.1 version installed that the source didn't. I don't know what else to try. Any suggestions would be most appreciated. Thanks in advance.

Thanks in advance, Ben

© Stack Overflow or respective owner

Related posts about sql-server-2008