title: SQL Server: How to list all CLR functions/procedures/objects for assembly
body: <p>Question: In SQL Server 2005, how can I list all SQL CLR-functions/procedures that use assembly xy (e.g. MyFirstUdp) ?</p>
  
  <p>For example a function that lists HelloWorld for query parameter MyFirstUdp </p>
  
  <pre><code>CREATE PROCEDURE HelloWorld
  AS EXTERNAL NAME MyFirstUdp.[SQL_CLRdll.MySQLclass].HelloWorld
  GO
  </code></pre>
  
  <p>after I ran</p>
  
  <pre><code>CREATE ASSEMBLY MyFirstUdp FROM 'C:\Users\username\Documents\Visual Studio 2005\Projects\SQL_CLRdll\SQL_CLRdll\bin\Debug\SQL_CLRdll.dll
  </code></pre>
  
  <p>I can list all assemblies and all functions/procedures,
  but I seem to be unable to associate the assembly to the functions/procedures...</p>