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.
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.