Is there a style check tool for T-SQL, just like FxCop to .net?

Question

I'm looking for a tool to enforce coding styles, validation check for T-SQL script. And it recommends best-practice when appliable.

In .net code domain, the tool for this purpose is FxCop. Is there a counterpart for T-SQL? It will be best it is free or open source tool.

Anyone can shed some light?

Answer 1

Power Tools is your best bet.

Also, here is a Microsoft tool for verifying best practices. The documentation specifies it checks T-SQL. It may or may not do what you want.

2000

2005