8.4. SOAP Request and Response Messages
When you are building a Visual Studio .NET application, Visual Studio .NET creates the necessary proxy class so that you can call a web service method almost exactly like you call any other method. The Visual Studio .NET application automatically builds the SOAP envelope for the request, and SQL Server processes the request, returning results in an object array or a single DataSet object.
If you are building an application that builds its own SOAP requests and processes its own SOAP responses, you need to understand the SOAP request and response message structures and the SOAP fault message structure. For more information, see Microsoft SQL Server 2005 Books Online.