BPA - SQL 2005 - T-SQL

Hi there

I am looking for some help with the BPA on SQL 2005, I can not seem to get it to recognise any T-SQL best practices, I can deliberately sneak in a SELECT * or INSERT INTO with no feild list into SP's but the BPA does not pick them up.

Am I missing something ?

Thanks

Tim

i hope this helps u

http://vyaskn.tripod.com/coding_conventions.htm

http://vyaskn.tripod.com/sql_server_administration_best_practices.htm

http://vyaskn.tripod.com/sql_server_administration_best_practices.htm

Madhu

|||

BPA is primarily concerned with security issues. It is NOT a code analysis tool. It does not check for coding standards and practices.

I suggest that you may wish to explore "SQL Refractor" from www.RedGate.com.

|||

Tim Hatcher wrote:

I am looking for some help with the BPA on SQL 2005, I can not seem to get it to recognise any T-SQL best practices, I can deliberately sneak in a SELECT * or INSERT INTO with no feild list into SP's but the BPA does not pick them up.

I've answered this and other questions in this blog post:

http://blogs.msdn.com/sqlrem/archive/2007/01/12/SP2-and-BPA-FAQ.aspx

"We used SQL Server 2000 Best Practices Analyzer 1.0 to check our T-SQL code. It is very useful in our development process. Why are you getting rid of it?
The best practices utilities across Microsoft are more focused toward operations/management. We are aligning SQL Server’s BPA to the corporate standard. We agree that there should be aids in checking best practices in code, but don’t feel that BPA is the right tool for the job. Software like FxCop or plug-ins to Visual Studio and Management Studio would be the ideal location for such checks."

There are also technical challenges around why we could not do it in this release. I apologize for the inconvenience.

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/