TSQL Code Checker

Is there a tool similar to FXCop that will check for TSQL ( or just SQL ) errors , ommissions etc and suggest code improvements ?

Also, along the same lines, are there client-side JavaScript and VBScript tools similar to FXCop ?

Thanks

[239 byte] By [JRCJames] at [2008-2-4]

«« Web site Unit Test: Object reference not set ... error
»» remote desktop whit a phone call!!!

# 1

The SQL Server Management Studio will show T-SQl errors, and you can also Execute the T-SQL with the Parse Only option, which will catch any errors that you have in the syntax. Are you looking for something that will suggest corrections as well?

BuckWoody at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Tools General...

# 2

Short answer: no.

Long answer: not really...
For SQL Server 2000, there is a SQL Server Best Practices Analyzer that does some basic code-checking of T-SQL on objects in your database.
http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

For SQL Server 2005, there is nothing available at the moment. We are making a new version of SQL Server BPA, but it will not have the T-SQL checking capabilities.

My team's blog talks about the next version of SQL BPA: http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+Best+Practices+Analyzer+Tool/default.aspx

If you'd like to see an FxCop for SQL Server, could you file this as a suggestion to Microsoft Connect? http://connect.microsoft.com/SqlServer/

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

PaulMestemaker-MSFT at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'TSQL Code Checker...'

TSQL Code Checker

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified