How to see assemblies loaded in SQL SERVER?

SELECT * FROM sys.assemblies_files

Sys.assemblies can be used to see the assemblies loaded in SQL SERVER.

Example:

Select * from sys.assemblies

If the files that were used to create the assemblies need to be viewed, sys.assembly_files can be used.

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........

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.......

Post your comment

Related Content