List CLR Objects in Database

Question

Post reply

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 1

akljfhnlaflkj

SSC Guru

Points: 76202

May 18, 2015 at 2:01 pm

#1798809

Thanks for the script.

Solomon Rutzky SSCoach Points: 16430 More actions · Answer 2

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