I am wondering what the industry is using to ensure that SQL Code meets coding standards and is error free. 

Thanx

 Adam
 

It all depends on how deep the pocket is...

if you want free tools there are from MS...

SQL Server 2005 Best Practices Analyzer (August 2008)

http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en

http://msdn.microsoft.com/en-us/sqlserver/bb671432.aspx

http://sqlcat.com/

http://www.codeproject.com/KB/architecture/T-SQL_Coding_Standard.aspx

Thank you for the reply.  As far as I am aware the Best Practice Analyzer only really analyzes things like security and server setup issues.

We have lots of developers so I was looking for a tool that would go through and point out things like "this proc uses a cursor" or this proc changed and takes a new parameter which broke this other proc.  It could run and analyze code and then create an error report.