Is there a way to find objects that do not compile

  • Hi All,

    I am wondering if anyone knows how to find objects on a database that dont compile, currently I have objects that done compile simply because a column name has changed or a column that was once present on a table has been removed.

    These objects are problematic on the database, especially when one scripts objects with the intention of running it on another server. I find it easier to remove such objects if no longer needed, but it feels like one know finds out of such objects during scripting or execution.

    Thanks

  • I can't answer this question, I just link the same question in SQL 2005 if someone knows how to do it.

    http://www.sqlservercentral.com/Forums/FindPost744460.aspx

    Gianluca

    -- Gianluca Sartori

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

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