query that select extended procs

[Indrek Mägi]

Hi
If I register my own proc via exec
sp_addextendedproc 'xp_myproc', 'xp_mylib.dll'.
How then I can look all my own procs and dll's?
In which tables are this data saved?

Thx.

[MarcM]

Not sure what you are after?

you can find what objects are extended proc from sysobejects where type =
'X' and you can get dll name out of syscomment text column but there is not
real automated way to get the source as it is not stored in dbms.

Hope this helps.
MarcM
"Indrek Mägi" <po*******@hotmail.com> wrote in message
news:d2********************************@4ax.com...

Hi
If I register my own proc via exec
sp_addextendedproc 'xp_myproc', 'xp_mylib.dll'.
How then I can look all my own procs and dll's?
In which tables are this data saved?

Thx.