Options

Invalid object detection - multiple databases

bootiedaybootieday Posts: 18
edited June 17, 2014 6:57AM in SQL Prompt
Is there any way possible to perform the "Find invalid objects" feature on multiple databases within a script?
· Share on Twitter

Comments

  • Options
    David PriddleDavid Priddle Posts: 218
    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
    · Share on Twitter
  • Options
    bootiedaybootieday Posts: 18
    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.
    · Share on Twitter
  • Options
    David PriddleDavid Priddle Posts: 218
    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
    · Share on Twitter
Sign In or Register to comment.