Hi,

I wrote couple of CLR stored procedures packaged in an assembly. Compiled it
on my Dev machine and for deploying this assembly to AS database server, i
followed:
http://msdn2.microsoft.com/en-us/lib...0(SQL.90).aspx

When i use a CALL DMX statement From Query Manager to execute any of the
function in this assembly it throws this exception:

Execution of the managed stored procedure TextXYZ failed with the following
error: Exception has been thrown by the target of an invocation.The type
initializer for 'TestAssembly.TestClass' threw an exception..

If instead of Executing i 1st try to parse it tells me:
"
Prepare is not safe during execution of the CleanupDeletedMeasurements
stored procedure."

On all my external available functions in the assembly i have used
SafeToPrepare(true) attribute.

On my Dev machine the same assembly run perfect without any such error. The
only difference is that on my Dev machine i compile and then use, on my Db
Server i just use the dll prepared on Dev box.


I don't know whats causing this. Any help will be great.