仅使用SQL Server中的数据库查找DLL SQL程序集

时间:2021-05-10 16:30:57

How do I find a DLL for a SQL Assembly in SQL Server if I only have the database?

如果我只有数据库,如何在SQL Server中找到SQL程序集的DLL?

1 个解决方案

#1


8  

SELECT 
    assembly = a.name, 
    path     = f.name
FROM sys.assemblies AS a
INNER JOIN sys.assembly_files AS f
ON a.assembly_id = f.assembly_id
WHERE a.is_user_defined = 1;

#1


8  

SELECT 
    assembly = a.name, 
    path     = f.name
FROM sys.assemblies AS a
INNER JOIN sys.assembly_files AS f
ON a.assembly_id = f.assembly_id
WHERE a.is_user_defined = 1;