Post reply

How do you find objects that are not compiling

  • August 10, 2009 at 4:49 pm

    #137921

    I need to be able to query all of the views, functions and stored procedures and see which objects will not compile. We had a developed drop fields or change tables and then we later found objects would not compile when we tried to mod the SP. In oracle it is simple to look in toad or sql navigator. Any ideas on how to do this in SQL Server 2005?

  • August 10, 2009 at 10:26 pm

    #1037221

    I can't think of a good way to do this in the DB, but good source control policies can help mitigate this. Also, your code should be periodically reviewed by more skilled SQL experts. Lax source control tends to be the cause of a lot of problems..

    CEWII

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

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