Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is there a way to find objects that do not compile Expand / Collapse
Author
Message
Posted Tuesday, June 30, 2009 8:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 12, 2014 8:17 AM
Points: 282, Visits: 1,104
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
Post #744458
Posted Tuesday, June 30, 2009 3:40 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 2:58 PM
Points: 4,655, Visits: 11,126
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

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #744944
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse