Saturday, February 25, 2012

query that select extended procs

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.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 Mgi" <polemeili@.hotmail.com> wrote in message
news:d2dn01dlmi8srm3mg4l3nginduo5661h5h@.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.

No comments:

Post a Comment