Extended Stored Procedures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Folke - 30 Mar 2004 12:11 GMT

I have written an Extended Stored Procedure and it works fine. In the installation intructions it is said that you must copy the .dll to SQLServer's binn directory. Why not put it in the GAC? (and ngen it!
/Folke

Reply to this Message

Joe Delekto - 30 Mar 2004 18:29 GMT

Greets,

The extended stored procedure is a normal Win32 DLL and not a managed
DLL (at least not yet). It requires being copied to that specific folder
because that is where the engine loads extension DLLs, using the
LoadLibrary()/GetProcAddress() Win32 API functions. It doesn't require ngen
because it's already native code. It's almost similar to an ISAPI filter,
only the IIS manager allows you to specify where that DLL exists.

Regards,

Joe

> I have written an Extended Stored Procedure and it works fine. In the installation intructions it is said that you must copy the .dll to

SQLServer's binn directory. Why not put it in the GAC? (and ngen it!)

> /Folke

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...