Is there a way to find objects that do not compile

• Dean Jones-454305

  SSCarpal Tunnel

  Points: 4804

  More actions

  June 30, 2009 at 8:32 am

  #100646

  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

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 30, 2009 at 3:40 pm

  #1018027

  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