Finding invalid objects

Brentw

"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

Luke Jefferson

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

Brentw

Thanks Luke! I am looking forward to it.