Does someone know a tool similar to fxcop for SQL ?

i.e. a tool that could scan SQL code (stored procedures/functions +
data model) to find possible design, performance, and security
improvements.

Database Tuning Advisor could be used for indexes and partition
improvement but I'm looking for a tool that would allow to find common
coding errors (e.g. no transaction with several data modifying
statements, no error handling, ...) and could be expanded with custom
rules.

Thanks in advance