Monday, February 20, 2012

Register dll

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