IMO if you have a "that should never" attitude towards dynamic sql or most other design decisions, you are doing your clients a disservice.  Technology should be used to solve...

Yes the database and log files are in the exact same directories.

Your arguement is certainly valid, but there are some very good reasons to abstract your middle tier from your database. 

First one that jumps out is how poorly TSQL organizes...

Not saying anyone is right or wrong here because TSQL means different things to different people, but SQL to me has always meant DDL and DML.  TSQL and PL/SQL are...

The ability to import an assembly and reuse code gives CLR a huge advantage.  Think about it...  one unified language in development, application automation such as Excel and Office, extensions...

This gets back to my COBOL arguement.  COBOL could do almost all the things that next gen languages could do, but it wasn't adept at it.  I believe T-SQL suffers...

No contridiction from my viewpoint.  SQL and T-SQL aren't the same thing.  I don't think SQL is going anywhere since it does what it does quite well, but the way...

I have worked on several n-tier apps and the logic has always ended up where it makes the most sense.  Everyone tries to keep it in the middle-tier, but often...

I agree queries will still be run, but that is what they will be... queries.  The logic I think will eventually (it will take years) be in a more progressive...

Given that I develop currently in SQL Server (over 9 years now) including its predecessor Sybase and even spent a couple years on PL/SQL.  I am well aware of what TSQL is...

Not buying it.  In many (read most) small companies, the dev is the SQL guy and the software developer.  Most small company devs will leave TSQL quickly since working in...