>>HI
>>
>>I have a c# CLR that I'm using to decrypt bank sort codes and account number.
>>
>>I've has an error that caused SQL to restart
>>
>>A fatal error occurred in the .NET Framework common language runtime. SQL Server is shutting down. If the error recurs after the server is restarted, contact Customer Support
>>
>>This seems to occur when I use the CLR in a table update rather than just decrypting one row.
>>
>>so
>>
>> update integra_live.dbo.xmasall set sortcode_decrypt = dbo.fn_RMB_RemoveCharacters(dbo.fn_RMB_bank_decrypt([Sort Code],@decrypt_key), '^0123456789') where [DD reference] = 'RWM000196'
>>
>>works
>>
>>and
>>
>> update integra_live.dbo.xmasall set sortcode_decrypt = dbo.fn_RMB_RemoveCharacters(dbo.fn_RMB_bank_decrypt([Sort Code],@decrypt_key), '^0123456789')
>>
>>fails
>>
>>any ideas why there should be this differnce
>>
>>as an extra confusion bith statements work perfectly on my development server.
>>
>>Thanks
>
>Is it possible that the value in Sort Code is not anticipated? Say, it's NULL or too long. Are you able to add more error handling into these CLR functions?

I don't think so. The data is an imported csv file. Imported into a temdb table and I've imported the same file onto both machines.