question

Steve Jones - Editor avatar image
Steve Jones - Editor asked

Creating an Extended Stored procedure in SQL Server 2000

Does anyone have a good resource and template on how to write an extended stored procedure for a SQL Server 2000 instance?

sql-server-2000stored-proceduresextended-stored-procedure
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Laerte Junior avatar image
Laerte Junior answered

http://msdn.microsoft.com/en-us/library/aa197263(SQL.80).aspx

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

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.