Somewhat padded article.

I wonder if SQL Server actually provides a facility to parse your SQL and highlight deprecated features. The runtime counters are handy but only count features which are executed so you can't guarantee to catch everything.

I remember someone in my team using WMI too. Not sure if it is as good as the other options listed in the article