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, October 17, 2014 7:27 AM
Points: 282, Visits: 1,096
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: Today @ 10:20 AM
Points: 4,392, Visits: 10,677
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