Microsoft® SQL Server 2012 Unleashed

Using the Related System Catalogs

As with other database objects, SQL Server provides catalog views that enable you to view loaded managed assemblies, routines, and types. The base view for finding these objects is sys.assemblies.

To see which assemblies have been loaded (including the one you created in this chapter), you use the following query:

Click here to view code image

SELECT TOP 5    name,    assembly_id,    permission_set_desc as permission_setFROM sys.assembliesORDER BY assembly_id descgoname                               assembly_id    permission_set----------------------------------------------------------------SQLCLR                             65719          UNSAFE_ACCESSSystem.Configuration.Install       65705          UNSAFE_ACCESS ...