Listing AS stored procedures

Is there a way to list the UDFs/stored procedures in a deployed assembly?

I donno, if I really understood your question...

TO list the stroedprocedures and Functions, you can use as follows

for StoreProcedures

select name

from sys.objects

where type in (N'P', N'PC')

for Functions

select name

from sys.objects

where type in (N'FN', N'IF', N'TF', N'FS', N'FT')

|||

This works nicely in SQL Server database. How would you do the same thing in Analysis Services?

In AS you can design CLR UDFs and stored procedures and deploy them in assemblies at database or at server level. Once you have more than a handful of them deployed, you would want to be able to enumerate them without having to open the source code. How else would you make them available to everyone writing MDX against the cubes in the corresponding database?

I have looked at XMLA and schema rowsets and I do not see a way to do it.

|||There is no schema row-set way to enumerate those, but if you have the assemblies on your drive you could run ildasm utility and browse the assembly for public classes and methods. Those can be used as stored procedures.

If you do not have the copies of the assemblies on your drive, there is a way to get them from the server. I forgot how to do it but i will post another reply soon (unless somebody will answer). Of course, it will work if you have permissions to get the binary back from the server.