May 27, 2009 at 4:08 am
Hi
I wrote a DLL that will be running on a Citrix hosted SQL server. This means that I don't have admin rights to the database and have to instruct someone to install the DLL. The administrator did not follow my instructions properly and I have no idea now what he called the procedure in my assembly.
Is there anyway to list all the functions / procedures that have been created from this assembly?
This is the code that was supposed to be used to created the procedure
Create Procedure uap_TransferControl
(
@ServerName nvarchar(max)
)
As
External Name ua_TransferControl.[ExternalGL.TransferControl].TransferFiles
Go
The DLL ua_TransferControl was loaded ok, but the procedure wasn't.
Any help will be much appreciated.
Thanks
Hank
May 27, 2009 at 8:51 am
Query the system DMV's for SQLCLR like this:
select assemblies.name as assembly_name,
object_name(object_id) as object_name,
assembly_class,
assembly_method
from sys.assembly_modules
join sys.assemblies on assembly_modules.assembly_id = assemblies.assembly_id
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 27, 2009 at 9:09 am
Brilliant! Thank you very much, that works a charm!!:-D
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply