Monthly Archives: August 2011

Aug 04

Get a List of CLR’s Registered to a Database

By SQLRx Admin | SQL Administration , SQL Server , Tip of the Month

Get a list of CLR’s registered to a database.  This is helpful when migrating or troubleshooting.  For more information on CLR’s check out Books Online or http://msdn.microsoft.com/en-us/library/ms131089(SQL.100).aspx   SELECT o.name AS ObjectName, a.name AS Assembly, o.type_desc AS ObjectType FROM   sys.assembly_modules am JOIN   sys.objects o ON am.object_id = o.object_id JOIN   sys.assemblies a ON a.assembly_id = am.assembly_id […]

Continue reading
>