You should not be putting your business rules into SQL Server if you are designing an n-tier solution. That essentially makes it two-tier.
>Hi
>
>What is SQL-Server's procedural language like? Is it any good to use as a middle-tier?
>
>This will be for a complex system where the rules are pretty heavy.
>
>Thanks
>Kev
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer