When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to verify an SQL statement, they should do the next:

–¬†Right-click in the SQL Pane, and select Verify SQL Syntax from the shortcut menu.


1. SQL Verification can detect some, but not all SQL errors. If a query contains an error not detected during SQL verification, the database will detect the error when developers run the query.

2. Queries that contain parameters cannot be verified.