List CLR Objects in Database

• harsha.majety

  SSCommitted

  Points: 1537

  More actions

  May 4, 2015 at 10:51 am

  #307710

  Comments posted to this topic are about the item List CLR Objects in Database

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 18, 2015 at 2:01 pm

  #1798809

  Thanks for the script.

• Solomon Rutzky

  SSCoach

  Points: 16430

  More actions

  August 23, 2016 at 7:43 am

  #1896908

  This script does not actually list all objects since User-Defined Types are not included. Please see my answer on Stack Overflow for a script that lists all SQLCLR objects:

  http://stackoverflow.com/questions/3155542/sql-server-how-to-list-all-clr-functions-procedures-objects-for-assembly/4768899#4768899

  Also, I prefer using the sys.assembly_modules DMV instead of sys.module_assembly_usages as it provides more information.

  Take care,

  Solomon..

  SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
  Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
  Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
  Info sites — Collations     •     Module Signing     •     SQLCLR