Set SQL Server Syntax

Question

Is it possible to set SQL Server 2008 R2 to just accept the ANSI SQL-92 syntax ?

So, when I do query using ANSI SQL-89 syntax, It will show some error.

If yes, how to do that ?

Thanks in Advance

Answer 1

No, but you can monitor for the use of deprecated features by using the SQL Server Deprecated Features Object performance counter and trace events. You won't get realtime warnings, but you don't want that anyway - it would break your apps. Instead, you just want to monitor afterwards to see what code you need to go fix.