Wednesday, March 21, 2012

Extended stored procedure using C# for SQL Server 2000

Can anyone of you help me in finding online - resources to write extended stored procedure for Sql Server 2000 using C#.

Thank you,

Andy Rogers

For SQL Server 2000, this would be non-trivial as you would have to write a native C/C++ extended stored proc which would serve as a "shim" to host the .NET runtime. If you would like additional background on doing this, check out http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconhostingcommonlanguageruntime.asp?frame=true

In SQL Server 2005, of course, implementations of stored procedures using managed code are intrinsically supported.

No comments:

Post a Comment