What would I like to see in SQL Server in the future?
1. Assertions (in the SQL standard since SQL-92. Until now no one has implement them - I hear Oracle are currently working on it).
2. Set based results from constraints. When a primary or foreign key is violated and multiple rows are effected then all rows that violate the constraint should be returned and not just the "first" one.