I developed CLR stored procedures assemblies using VS2005 and deployed in sql server 2005 are working fine. Currently we are migrating to sql server 2008. The same CLR assemblies are not working in 2008 version and raising following error. Here i created
CLR assemblies in sql server 2008 using 'sa' user account which is having db_owner permission over 'mydatabase'.
I am getting an error message like "A .NET Framework error occurred during execution of user-defined routine or aggregate".
In sql logs showing messages like as
-- Common language runtime (CLR) functionality initialized using CLR version v2.0.50727 from C:\Windows\Microsoft.NET\Framework\v2.0.50727\.
-- AppDomain 2 (mydatabase.dbo[runtime].1) created.
Please let me know what may be the cause for this type of issues.
Is there any specific backward compatibility settings has to be done over sql server 2008 or sql server 2008 R2 while using 2005 CLR routines?
Thanks in advance.
View Complete Post