It appears that CLR integration does not like Dotnet framework 2.0 sp2. I am getting the following error message when trying to run code that depends on the clr.
Msg 6510, Level 16, State 11, Line 1 Common Language Runtime (CLR) v2.0.50727 not installed properly. The CLR is required to use SQL/CLR features.
I have verfied with the dotnet verification tool that the dotnet framework for all versions installed work.
I have only found possibly one hint that this is whats causing the issue. I would think thought that if this was the case more people would be screaming. Does anyone have any suggestions on how to track this down better. We have a few systems that are relying on this implementation.