I would like to register the cpx.dll as an external stored procedure for
"xp_cpx.
Please let me the procedures to complete this task?
Thanks"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:5A5FCB65-476C-40B6-A1B7-0DD7409BC355@.microsoft.com...
> I would like to register the cpx.dll as an external stored procedure for
> "xp_cpx.
> Please let me the procedures to complete this task?
> Thanks
>
From the Books Online
Adding an Extended Stored Procedure to SQL Server
A DLL that contains extended stored procedure functions acts as an extension
to Microsoft SQL ServerT. 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).
To add each extended stored procedure function in an extended stored
procedure DLL, a SQL Server system administrator must run the
sp_addextendedproc system stored procedure, specifying the name of the
function and the name of the DLL in which that function resides. For
example, this command registers the function xp_hello, located in
xp_hello.dll, as a SQL Server extended stored procedure:
sp_addextendedproc 'xp_hello', 'xp_hello.dll'
It is not necessary to stop and restart SQL Server. This is in a sample only
available if you select Dev Tools during setup.
No comments:
Post a Comment