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

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial