Extended Stored Procedure

Could someone who has done it before be kind enough to post a short example of how to make a call from an extended stored procedure to a .NET DLL? Or even direct me to an example, or tell me that this is possible / not possible, it would help.

Thanks,
Brian

Theoffficial position from Microsoft is that they do not support the use of the CLR for extended stored procedures
At one point I had considered trying to use regular expressions withSQL Server 2000. Here'a a CodeProject article explaining how togo about it:xp_regex:Regular Expressions in SQL Server 2000. This also covers the topic of running managed code from an extendedstored procedure. Maybe you will find something in there to helpyou.
|||

Yes I was slowly finding this out through my research last night. Thanks for the validation, and I will check out your code.

I did find someone who did it anyway by wrapping a COM object:
http://sqljunkies.com/Article/C5A500EB-B8BE-42C0-B23B-258A342CAAAB.scuk

Who knows what kind of problems that could cause.

My solution is apparently around the bend in SQL Server and Visual Studio 2005 though. SQL 2005 natively supporting CLR.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnreal/html/realworld03112005.asp

Thanks for the feedback, if anyone has comments about the above please don't hold back.

Brian

|||Just to be clear, nothing I provided is my own code, just what I found when I researched the same subject.
And indeed, SQL 2005 will be your answer!
|||

I have seen Jeff Prosise live use them in a Demo at our .NET user group but Jeff Prosise is the person to call if you want to know MFC(Microsoft Foundation Class). I would swing by BMC website to test drive their SQL Programmer tool because anything you can do in SQL Server their tool will do it. They bought the best Transact-SQL minds in 1999. I would also browse Ken Henderson books at my local book store, there are three of them on Transact-SQL because he covers undocumented DBCCs and functions that may help you. Hope this helps.

http://www.wintellect.com

http://www.bmc.com/products/proddocview/0,,0_0_0_8739,00.html

Kind regards,

Gift Peddie