Hugo Kornelis (12/21/2012)

My point is also not that I want the current implementation of UNIQUE removed from the product.

My point is that IF a feature is implemented that has the same name as a feature in the ANSI standard, then it should behave exactly as described in that standard. If a vendor chooses to offer additional options as well - fine, but use optional keywords for them, and make sure that the defaults are for ANSI behaviour.[/quote-0]

Hugo you are better than this.

MS SQL Server is an ACID compliant Transactional RDMS system that Logs all DML.

It also supports ANSI SQL as a secondary language. :w00t:

So your arguments suggesting we should limit our Choices and options as DBA's and Developers when using MS SQL server so it will support some language standard that is secondary to T-SQL and ACID support seem very contrary and argumentative. 😎