Does anyone have a good resource and template on how to write an extended stored procedure for a SQL Server 2000 instance?
But there is not much secret , and you need to know C/C++. You can use the gcc compiler (free) , it had the Windows development and is also free Dev-C++, donwload -> http://www.bloodshed.net/devcpp.html.
build the DLL and use
sp_addextendedproc to add in sql server 2000
No one has followed this question yet.