How can we help you today? How can we help you today?

Invalid object detection - multiple databases

Is there any way possible to perform the "Find invalid objects" feature on multiple databases within a script?
bootieday
0

Comments

3 comments

Sort by
  • David Priddle
    Hi bootieday,

    Unfortunately we don't have this functionality available in SQL Prompt at the moment.

    In which situations would this be useful for you? It would be great if we could have a scenario to help understand your problem.

    Best regards,

    David
    David Priddle
    0
  • bootieday
    Our scenario is one in which we have hundreds of production databases of identical schema structure. It would be good to have a mechanism to collect this invalid object information periodically to help troubleshoot potential deployment issues in our environment.
    bootieday
    0
  • David Priddle
    Hi bootieday,

    I've just noticed there is an existing feature request for SQL Prompt to have Find Invalid Objects work globally. Would this solve your problem?

    Best regards,

    David
    David Priddle
    0

Add comment

Please sign in to leave a comment.