How to execute dynamic .net code in clr stored procedure in SQL Server?

I'm not a CLR assembly expert, but the obvious options are.

I'm not a CLR assembly expert, but the obvious options are: ALTER ASSEMBLY Drop and re-create the assembly inside a transaction Define a maintenance window and deploy it then gbn's point about release processes is a good one. If your procedures (and therefore your business operations) are really constantly running 24x7 then presumably you already have some form of system redundancy and established maintenance procedures for patching and upgrading applications? If so, just deploy your new code in your usual maintenance window.

After revisioning the idea, I found out that redeployment is needed in quite rare cases so we can perform in when no one is connected (the application isn't runnuing 24x7). @Pondlife, @gbn you were right: the question was about release process (but it was obscured) – Dima May 23 at 13:38.

There's a good library for dynamic evaluating arithmetic expression (with parameters) - Flee In my case I didn't have to execute any . Net code - just the expressions like "Date > '20100101' Or Status = 2", so Flee satisfies almost completely. The only issue is that its logical operators don't work with SqlBoolean type (which is used in sql expressions) but it's not a big deal to add this feature.

But in general case it's seems to be impossible to execute dynamic . Net code inside Sql Server host.

It is impossible because Reflection. Emit is blocked by the Host Protection Attribute. See msdn.microsoft.Com/en-us/library/ms403285.

Aspx – Filip De Vos May 30 at 9:13.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.