Extended Store Procedure Query

Please help me..
I am stuck on the Problem related to Store Procedure
I want to use Extended Store Procedure.
I read tech document related that on MSDN,
but i am unable to register the Extended Store Procedure.
Please guide me step wise step, So that I can register the extended
store Procedure (.DLL)
File in SQL Server.
I also want to Kow How to use it in our Program.
With regards
Tarun SinhaCopy the DLL into a suitable directory on the machine running
SQL Server, typically
C:\Program Files\Microsoft SQL Server\MSSQL\binn
Register the extended stored procedure using
exec sp_addextendedproc N'myxp', N'myxp.dll'
You can execute it using
exec master.dbo.myxp
remembering to supply any parameters it requires.|||To install the DLL,
copy the file to the directory containing the standard SQL Server DLL
files (C:\Program Files\Microsoft SQL Server\Mssql\Binn by default).
then run this (of course your name will be different)
sp_addextendedproc 'xp_YourProc', 'xp_YourProc.dll'
http://sqlservercode.blogspot.com/|||Hello
Thank's for replying me
I would I Know What Parameter the Extended Store Procedure Take .
Please consider this Stupid Question and reply me.
I download xpRegex.dll and copy it in C:\Program Files\Microsoft SQL
Server\MSSQL\binn ,
I Also Register in the extended store Procedure, but How to Know what
parameter it takes.
With regards
Tarun sinha|||In order to find out the parameters it needs for execution, you
will need to refer back to the documentation from where you
downloaded it. You can't tell otherwise.
Registering it doesn't require any parameters, although it is possible
to have multiple entry points in the same DLL. In which case
you would call sp_addextendedproc once per entry point, e.g.
exec sp_addextendedproc N'xpRegex_X', N'xpRegex.dll'
exec sp_addextendedproc N'xpRegex_Y', N'xpRegex.dll'
All this should be explained in the place where you downloaded it.|||Thank You sir
U explain my query so well ..
I am great thank ful to you
with regards
Tarun Sinha