I am looking for a way to query the MSSQL database for ‘invalid’ procedures and/or views. Oracle allows you to very simply query the user_objects table for objects with a status <> ‘VALID’. However, it does not seem this cut and dry with MSSQL. Is there a way to check the status of procedures, functions and views in MSSQL?
