General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only