Hi there

Yep, its called "SQL Server Web Services", its basically an IIS ISAPI extension + UI that allows you to very quickly create webservers (soap or not) from db stored procs. YOu can also hook in templates, return straight record sets etc. It is quick and easy to use. Search on MSDN for it. I have cutover a range of previously coded webservers in vb and using the soap toolkit with the wsdl gen etc.

One important note - what about security?? take care with this. Managing security is a pain with webservices and must be well thoughtout re the issues.

Only 1 problem with the "db" approach to webservices, is that you cant leaver off any business tier logic embedded in class methods. This can skew your webservices implementation in that your webservices are toolkit driven via code or ISAPI pre-generated drived through the SQL webservices IIS extensions. Just a pain to document and administer nicely.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"