The Daily Dose

The Prescription for SQL Server

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   SELECT AS ObjectName, 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