Post reply

Utility to check Stored Procedure syntax against data base changes

  • September 17, 2004 at 10:30 am

    #59983

    Hi,

    Is there any utility that will run through all the stored procedures in a SQL Server and verify the syntax, specifically finding any stored procedures that will need to be modifed due to a database change. Like renaming a column or table.

    Thanks ....

  • September 17, 2004 at 12:16 pm

    #523547

    There may be a better way, but it occurred to me that the following should work at least for the most part.

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=136926#bm137004

    A more manual process would be to run content scans on the SPs for the table name you are modifying and then looking at the SQL to determine if it will need to change. I expect that searching this site should reveal several ways of doing that search.

  • September 17, 2004 at 12:31 pm

    #523551

    Thanks for the suggestion.

    I guess what am after is the same function as the "Check Syntax" button in the Stored Procedure code window. This checks the syntax of the sql and verifies against the database. This process is what I'm after except it would cool to just run through all stored procedures and views and then spit out a list of items that need to be fixed.

    Any clues?

    Thanks ...

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply