Fog Creek Software
Discussion Board

Welcome! and rules

Joel on Software

External stored procedures

What are some of the best ideas people are using to make external business logic written in DotNet available to SQL Server stored procedures and triggers?
Current choicese are:
1. make the stored procedure call OLE/ActiveX objects as before using sp_oa* functions.

2. Execute xp_ shell options that calls a stand-alone application

Are there patches for the mentioned databases I can download from Microsoft to make accessing external procedures or business logics written in DotNet easier?

Li-fan Chen
Thursday, September 19, 2002

Li-fan Chen
Thursday, September 19, 2002

Maybe not directly on topic, but I read an article with one of the .NET developers at Microsoft that sometime in the future that you will be able to write stored procedures in SQL Server in the .NET language of your choice (C#, VB.NET, etc.).  So, I would assume that this means that your stored procedure could access external .NET assemblies and the types defined in those assemblies.

Thursday, September 19, 2002

You can write a linkable DLL, which I assume you can do with Unmanaged, mentioning it just to be complete.

Li-fan Chen
Thursday, September 19, 2002

Microsoft has said that the next version od SQL Server "Yukon" will support .Net as well as T-SQL in stored procedures.

Bored Coder
Friday, September 20, 2002

*  Recent Topics

*  Fog Creek Home