I was trying to create a Job for invalid objects that could check the invalid objects of all user DB and send a report to our mail. please help me on this scripting.

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.

more ▼

asked Jan 12 at 07:27 AM in Default

avatar image

1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jan 12 at 02:16 PM

avatar image

Usman Butt
14.9k 6 13 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 12 at 07:27 AM

Seen: 29 times

Last Updated: Jan 12 at 02:16 PM

Copyright 2018 Redgate Software. Privacy Policy