title: How to find list of all views which gives error in specific database?
body: <p>How to find list of all views or store procedures that gives error while executing in database? </p>
  
  <p>sometime user made changes in views (deleting the specific field in view) without checking its dependencies. All the dependent views and store procedures using the views then gives error, XXX column is missing.
  Is there any specific script to check all the list of views and store procedures that gives error while executing.</p>