Create a web service directly from Sql Server 2005 using an HTTP Endpoint (http://codebetter.com)

What is an HTTP Endpoint in Sql Server?  Well, it is a way to
create a usable interface using HTTP or TCP for SOAP, T-Sql, Service
Brokering and a few other things.  I’m just going to tell you,
quick and simple, about creating a web service to return data, although
you can return scalar values, messages and errors too.  The
results returned are serialized into Xml.  If you have Windows
2003, you don’t have to have IIS installed.  Sql server will use
the http.sys module in the Win2K3 kernel.
So lets look at creating a usable web service from within Sql Server.  Lets start with creating a stored procedure.
Create stored procedure to return list of employees