Invalid Objects or future enhancement

Elizabeth_Close_M1st

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?

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.

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

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