SQL Query Inspector

A tool to detect table sequence anomalies in SQL Server triggers, views, stored procedures and user defined functions
Download

SQL Query Inspector Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Free to try
  • Price:
  • Free to try
  • Publisher Name:
  • By Manchester SDL
  • Operating Systems:
  • Windows, Windows 2000, Windows XP, Windows Vista
  • Additional Requirements:
  • Windows 2000/XP/2003 Server/Vista, Microsoft .NET Framework 2
  • File Size:
  • 2.33MB
  • Total Downloads:
  • 1044

SQL Query Inspector Tags


SQL Query Inspector Description

SQL Server deadlocks can be caused by inconsistent sequencing of database tables in SQL statements used in stored procedures, views, triggers and user defined functions. Best practice recommendations always suggest that tables in T-SQL statements be specified in the same relative order where ever possible. SQL Query Inspector is the fastest way to detect table sequence problems that occur in database code. SQI can reduce the time it takes to locate these issues from days or weeks, down to minutes. SQL Query Inspector will analyze 100% of the SQL statements in a database and report all table usage inconsistencies using a pair of interactive data grids. The grids can be sorted by any column to allow rapid determination of modules and tables with potential problems. The actual module code can be extracted to Notepad for viewing or for cutting and pasting into Query Analyzer or Management Studio. Get SQL Query Inspector and take it for a test run to see what it can actually do for you!


SQL Query Inspector Related Software