Just found a remote database that did not have a field in a table which had been added some 4 or so scripts ago. That makes me suspect of all script updates.

What is the fastest and most reliable way to check all my deployed databases (say 200 of them) to see if all the scripts have run correctly and applied the changes, or created triggers and procedures, contained in previously run scripts?

Do I need a commercial product that can help? Or do I just have to "visit" each location and check the database structures manually?

Thanks!

-Eduardo