Arthur Fuller
fuller.artful at gmail.com
Tue May 8 09:17:04 CDT 2007
There is no requirement for the middle tier to have a new instance of SQL. In fact I have no idea how you arrived at that thought. The general thinking behind 3-tier architecture is this: 1. client has minimal hardware and minimal installation. Client software has no idea where the database lives, and speaks only to Miss Middleton. 2. Miss Middleton treats all her clients as equally worthless, but does translate their requests into requests from the database, whose address only Miss Middleton knows. 3. The database developers are free to rewite any sprocs and UDFs and views as they please, so long as Miss Middleton is undisturbed. They can even redesign tables, since any good designer forbids direct access to tables. So middle-tier Miss Middleton controls every access to every table, whether it be through a sproc or udf or view or materialized view. Arthur On 5/8/07, Gustav Brock <Gustav at cactus.dk> wrote: > > Hi Shamil > > I must believe you here as I haven't done much programming in SQL Server > and you have so much more experience in this area. > However, to me a middle-tier can be made from anything that fits the > purpose, and if that calls for another instance of SQL Server, that's fine > with me. Actually, it sounds like it could be a very clever solution. > > /gustav > >