Link to home
Create AccountLog in
Avatar of Danie1
Danie1

asked on

Show extended procedures + dlls path

Hi.
MSSQL extended procedures can be added by command:

exec master.dbo.addextendedproc 'my_proc','c:\my_proc.dll';

How to get a list of all added extended procedures like this:

my_proc : c:\my_proc.dll
my_proc2 : c:\my_proc2.dll
etc...

P. S. MSSQL 2000

Avatar of arbii
arbii

This shoudl list all the extended stored procedures -
select * from sysobjects where type = 'X'
Avatar of Danie1

ASKER

Yes, but without dll path :(
ASKER CERTIFIED SOLUTION
Avatar of arbii
arbii

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Alpesh Patel
you may found in sys.assemby.
Avatar of Danie1

ASKER

Thank you for nice solution!