• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • Last Modified:

SQL Query Validator for SQL Server

Hi Experts,

     I am looking for a SQL query validator (free or paid) for SQL Server/SQL Management Studio.  Basically I am looking for a tool that makes sure that all referenced objects (tables (both actual and temp), columns, functions, sprocs, user defined types, etc.) in every sproc/function/etc. exist in the database.

     We have been wasting a lot of time lately due to people removing/changing the spelling of objects and we don't find out about it for a while.  Is there a tool that you all know of that I could run on a database/or at least a script and validate it against an existing database to verify the above things?  I need the tool to work on MS SQL Server '08R2 or higher

Thanks!
0
axnst2
Asked:
axnst2
  • 2
2 Solutions
 
Kyle AbrahamsSenior .Net DeveloperCommented:
http://download.red-gate.com/HelpPDF/DatabaseUnitTestingWithRedGateSQLTools.pdf

Looks like redgate's Sql tools may be a bit of overkill, but depending on your project size may also help you out.  I wouldn't say it does the validation per say, but it can use the data generator to fire off the stored procs .  . . and even gives you validation against it.
0
 
axnst2Author Commented:
Yes, I am not looking to spend days on setting this up.  I'm just looking for a simple like 'Check' button
0
 
Éric MoreauSenior .Net ConsultantCommented:
I had the same problem in the past. I solved half of it. Check http://emoreau.com/Entries/Articles/2010/02/Validating-database-objects.aspx
0
 
axnst2Author Commented:
Thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now