Use SQLXML 3.0 to expose your stored procedures as Web services

The latest technology buzz is Web services. Terms such as Simple Object Access Protocol (SOAP), Web Services Description Language (WSDL), and Universal Description, Discovery, and Integration (UDDI) now appear in almost all marketing materials about XML and the Internet. But how are Web services relevant to you as a SQL Server professional?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag02/html/CreatingaWebService.asp