Search code examples
c#sqlstored-proceduressql-server-2000extended-procedures

How to create an extended stored procedure in SQL Server 2000

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.

Solution

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