O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required