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?
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.
You can write a linkable DLL, which I assume you can do with Unmanaged VC++.net, mentioning it just to be complete.
Microsoft has said that the next version od SQL Server "Yukon" will support .Net as well as T-SQL in stored procedures.
Fog Creek Home