The status of whether an object is valid or not is not stored anywhere, so you have to discover it on demand.For views, you can run the procedure sp_refreshview [viewname]; if it can be recompiled, you are all set, else it raises an error. similarly, to check a procedure or function, you have to ALTER the object and see if it fails or not.