Suggestion - database integrity check
When developing databases, particularly in the early stages, I frequently make large changes to the structure of tables and some of the stored procedures don't always catch up. It would therefore be useful to have an extension to SQL Refactor (or perhaps SQL Compare) where you can run an integrity check on the entire database to make sure that all is well before attempting to use SQL Compare to copy it to a test environment. SQL Compare does throw errors if the stored procedures contain invalid columns, so it should be a small step (?) to be able to list anomalies for the entire database.
0 · Share on Twitter