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

Invalid Objects or future enhancement

Elizabeth_Close_M1stElizabeth_Close_M1st Posts: 9 New member
edited November 9, 2017 6:44PM in SQL Prompt
I tried to use InvalidObjects finder to list DB objects that use a LinkedServer that either "doesn't exist" or "doesn't validate" ... is there another way (besides drop/recreate) that will find these?
Tagged:

Best Answer

Answers

  • Options
    Eddie DEddie D Posts: 1,793 Rose Gold 5
    Hi,

    Thank you for your forum post.

    There is not an InvalidObject finder within SQL Dependency Tracker. Please reply with details of what you are viewing when using SQL Dependency Tracker?

    Unless you are referring to the Find Invalid Objects feature of SQL Prompt?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    Hi Eddie - You are correct, It's in SQL Prompt. I deleted all linked servers from my local instance and wanted to find out which ones I really needed but Invalid Objects didn't see the linked server(s) being missing

    Thanks
    Elizabeth
Sign In or Register to comment.