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!
axnst2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Éric MoreauConnect With a Mentor Senior .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
 
Kyle AbrahamsConnect With a Mentor Senior .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
 
axnst2Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.