Extended Stored Procedures

Question

Extended Stored Procedures

Alex Wilson-148544

SSC-Addicted

Points: 470
More actions
January 13, 2005 at 2:57 am

#102349

Morning Guys,
(I have accidently mis-posted this in the notification..administration section, my apologies!)
So i'm not so sure this is specifically a Administration related question or Development, possibly both.
I have some routines I have written in C# that perform particular system functions, like shutting down a server, performing basic ftp functions, you get the idea.
I want to now load these into SQL Server as extended stored procs? But havent got a clue how to? and cant find anything on the web that specifies what my .dll should look like? (I'm assuming its a .dll I need), how I load it up on SQL Server or how SQL Server will manage its execution?
Does anybody have any links, suggestions to help with this, perhaps a book ISBN
Even an 'hello, world' example would be cherished.
Thanks in advance,
Alex Wilson

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Have a look here in BOL: sp_addextendedproc

I'm not familiar with C#, but currently you can write extended stored procedures only in languages that are able to generate true Win32 executables, such as C, C++ or Delphi. Only such languages can export functions. So, if C# can also do this, that's fine, otherwise you're out of luck and can only instantiiate such COM DLL's via the sp_OA* procedures. See, if this provides additional help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322884

http://www.support.microsoft.com/?scid=kb;en-us;190987

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]