02:17
Unknown
No, it does not allow all .NET assemblies to execute example :- System.Windows.Forms, System.Drawing, System,Web etc are not allowed to run.SQL Server maintains a list of .NET namespaces which can be executed, any namespaces other than that will be restricted by SQL Server policy.
This policy checks are made on two instances:-
=> When you are cataloging the assembly.
=> When you are executing the assembly.
Readers must be wondering why a two time check. There are many things in .NET which are building on runtime and can not be really made out from IL code. So SQL Server makes check at two point while the assembly is cataloged and while it's running which ensures 100 % that no runaway code is going to execute.
This policy checks are made on two instances:-
=> When you are cataloging the assembly.
=> When you are executing the assembly.
Readers must be wondering why a two time check. There are many things in .NET which are building on runtime and can not be really made out from IL code. So SQL Server makes check at two point while the assembly is cataloged and while it's running which ensures 100 % that no runaway code is going to execute.
0 comments:
Post a Comment