How get all installed assemblies in a SQL Server database? (sys.assembly_modules doesn't show them)

Question

When I go into SQL Server Manager, I can see:

MyDatabase ->Programmability ->Assemblies ->Microsoft.SqlServer.Types ->MyAssembly ->Newtonsoft.Json

But when i run:

select * from sys.assembly_modules;

I get no rows.

NOTE: I am logged in as 'sa'

Why? How do i list the assemblies installed?

SMM · Accepted Answer · 2017-01-25 22:05:44Z

1

This works for me:

select * from sys.assemblies

answered Jan 25, 2017 at 22:05

2,2351 gold badge21 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1