How is .NET Appdomain allocated in SQL SERVER 2005?

How is .NET Appdomain allocated in SQL SERVER 2005?

.NET Appdomain allocation depends on the following:
- For every database a different Appdomain is allocated
- For every user a different Appdomain is allocated

How is .NET Appdomain allocated in SQL SERVER 2005?

A separate Appdomian is created for each database in order to run the database code. The appdomain may be allocated based on identity of the user who owns the assembly. The memory allocated to the instantiations of .Net type objects is done from a pool of close memory managed by CLR. The .Net framework also has a garbage collector for unusable objects and reclaiming the memory.
Syntax for creating a new assembly in SQL Server 2005
Assemblies can be created using CREATE ASSEMBLY command. It takes the path of the DLL as the parameter........
CLR Integration vs. Extended Stored Procedures
CLR Integration provides a more convenient and robust solution to Extended stored procedures for implementing server side logic.......
How to configure CLR for SQL Server?
CLR by default is not configured in SQL server. It needs to be explicit ally configured using sp_configure syntax. This is shown as below:........
Post your comment