We have query for finiding invalid object for one database, But i need to get invalid object for all User db and send it through mail.
asked Jan 12 at 07:27 AM in Default
Please have a look at Making a more reliable and flexible sp_MSforeachdb to get the required information from all the databases. If it does not fulfill your requirement, then you can easily modify it according to your needs or at least get the basic idea.
answered Jan 12 at 02:16 PM