Post reply

Is there a DMV that tells you about objects that dont compile or broken dependencies ?

  • June 30, 2009 at 8:33 am

    #132355

    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

  • June 30, 2009 at 3:37 pm

    #1018024

    Unfortunately I don't know the answer, I'm here just to link your post in the sql 7,2000 forums, so that if someone knows the answer for SQL 2005 maybe could work on it for previous versions.

    http://www.sqlservercentral.com/Forums/FindPost744458.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