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

Invalid Objects or future enhancement

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?
Elizabeth_Close_M1st
0

Comments

3 comments

Sort by
  • Eddie D
    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 D
    0
  • Elizabeth_Close_M1st
    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
    Elizabeth_Close_M1st
    0
  • way0utwest
    Reproduced this. I created a proc that uses a linked server, then deleted the linked server. Find Invalid Objects in Prompt doesn't detect this. Reported to the team.
    way0utwest
    0

Add comment

Please sign in to leave a comment.