How to create an extended stored procedure in SQL Server 2000

Question

I need to create an extended stored procedure in SQL Server 2000 using Visual Studio. It worked fine in SQL Server 2008 and 2012. I followed the instructions described here after adding the dll the stored procedure does not run!

The procedure to create extended procedure described here for SQL Server 2012. But I need to create the same thing in the same way in SQL Server 2000.

Answer 1

You just cannot do this.

SQL Server 2005 and newer introduced this CLR support - the abilty to include .NET code inside SQL Server.

SQL Server 2000 has no similar features. You'll need to resort to native C++ APIs - check out this link here for starters.

Answer 2

Simply not possible, I'm afraid.

If you look at the page you linked to (http://msdn.microsoft.com/en-us/library/ms164653.aspx) you'll see that SQL Server 2000 is not listed in the 'Other Versions' drop down.