Archives
-
HTTP Endpoints in SQL Server 2005
SQL Server 2005 ( Codenamed "Yukon" ) provides a new interesting feature to execute stores procedures or Transact-SQL statements through web services published in the server, without need to use IIS.
This new feature exposes Http endpoints using the Http Api provided in Windows XP SP2 and Windows 2003.
These endpoints are published in a specific URI, and they listen for incoming soap requests, so they facilitate interoperability because any application, which talks soap, can communicate with SQL server without requiring additional sql libraries or MDAC. -
Writing managed custom actions in an easy way
In my last post, I talked about hosting the CRL within a native custom action.
This week I found an easier way to execute a managed custom action, it is based on a hack and not extra C++ code is required.
Actually, you can't write a C# custom action because the compiler doesn't allow you to create a __stdcall function to be
called from the outside.
Well, take a look to this article, it shows how to overcome that problem. -
Hosting the CLR within a custom action
Today, in order to develop a custom action for a Window Installer setup, you can choose between two options: