Regardless of your opinion on SOAP (and I don't hate it nearly as much as some other folks here), having the SQL Server dishing it out directly was always kind of silly. Thats what a Web Server is for.
Amen to this. DBA 101: - Limit your connections to the database. - Let the database do what the database is designed to do. - For the love of FSM, eliminate dynamic SQL. Cheers, -m