>We have made some major changes to our tables. Is there a way to programmatically syntax check all stored procedures all at once?

We use a tool called DB Ghost to do this. Basically you script all the objects in the data base. This tool creates a db from all the scripts. If there are any errors it will report them to you.

I have used NAnt to automate running this every hour in our shop. The task gets the new scripts and does a validate (that's what db ghost calls it). If there is an error the task emails the error to all the developers. This way, problems can be found and fixed right away.

BOb