﻿ SQL Server 2005: a 3-tier purist's nightmare | ZDNet  SQL
Server 2005: a 3-tier purist's nightmare  Summary: SQL Server
2005, now available as a "community technology preview,"  is an
odd beast.  For those who believe their databases should be
little more than simple data access routines with business logic
placed at the "middle tier," the move towards application server
technology integrated as part of a database is a Bad Thing.
Oracle integrated the Java VM a while back.  With .NET now fully
integrated into SQL Server, the trend towards moving business
logic into the database is enough to make the 3-tier purists
wake up screaming in the dead of night.  I've never understood
the purists.  I tend towards long stored procedures with lots of
business logic.  I also tend towards transactions at the stored
procedure level.  Databases are a single access point, and it
makes sense (at least to me) to try to keep transactions within
stored procedure boundaries.  Of course, that's not always
possible.  When you a