Hi Shane, There is a third option to consider. Even if I am not a big fan of it, SQL Server 2005 allows for stored procedures to be exposed as web services, directly hosted by SQL Server via the http.sys functionality (the same used by IIS itself). It could sometimes provide the right trade-off when the power of web services is needed but the performance impact have to be considered.
Here is a couple of urls to check out: [1] http://msdn2.microsoft.com/en-us/library/ms345123.aspx [2] http://msdn2.microsoft.com/en-us/library/ms345140.aspx HTH, Efran Cobisi http://www.cobisi.com Shane Courtrille wrote:
Has anyone seen numbers on using a web service as an intermediary for your data access vs directly accessing SQL server? In an internet environment I think web services are a must in terms of security and just the basic act of connecting. Not many places are willing (or should) open the ports that SQL server needs. But in an internal network I have definite questions over which is preferable. Thanks, Shane =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
=================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
