Is there any BPA for procedures ?

Hi all,

Is there any best practice analyzer for analysing the SQL objects like stored procedure, functions and views ?

Thanks in advance,

DBLearner

Unfortunately, there is not.

Coding Standards and Peer review IS the 'best practice analyzer'.

|||

You could use the SQL Server 2000 Best Practices Analyzer:

http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

...or the February CTP version for SQL Server 2005:

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

Chris

|||They are planning to move something like this in one of the next versions of VSDB.

Jens K. Suessmeyer.

http://www.sqlserver2005.de