How to edit a CLR function in sql server 2008?

Question

In a current project there are some user defined CLR aggregate function.

Now I have to edit it. How can I do this?

And how to fine where .dll file is saved?

Is there any way to check what is written in the function from sql server?

Answer 1

You can execute the query select * from sys.assembly_modules to get the list of assemblies. You can view the function if you expand the Database --> Programmability --> Functions --> Aggregate Functions