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: 284
sql-server-2008
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