I think it's unfortunate that MS doesn't provide an automated tool to review a SS database for standards compliance. The nice thing about FXCop is that it's somewhat easier to convince an organization to use FxCop to enforce "Microsoft Standards".

Is there an automated SQL standards tool available that validates databases based on rules published by some other recognized SQL standards organization?