What are the challenges you face when working across database platforms? Take the survey

Finding invalid objects

BrentwBrentw Posts: 3
edited December 17, 2010 8:49AM in SQL Prompt Previous Versions
"Finding invalid objects" is a nice addition to SQL Prompt but is there a way to export the object list? I would like to be able to create a spreadsheet with the info from the top pane. It would also be nice to be able to run this on all databases on a server with an additional column in the top pane for the database name.

Thanks, Brent


  • Options
    Hi Brent,

    Thanks for the kind words and the feedback.

    Your first suggestion should make it into SQL Prompt in the new year -- we had planned to include this but decided to release now to get feedback. We plan to let you copy the list and also to display a count of invalid objects on the FIO tab.

    Your second suggestion is a good one so I'll put that on the backlog though there may be some issues we need to tackle around performance first.

    Thanks again for your contributions -- really useful to the team. Do feel free to email me directly should you have any more suggestions or feedback.

    All the best for now,

    Luke Jefferson
    Product Manager
    Red Gate Software
    Email: luke.jefferson@red-gate.com
  • Options
    Thanks Luke! I am looking forward to it.
Sign In or Register to comment.