Invalid Objects or future enhancement

Elizabeth_Close_M1st · November 9, 2017 6:44PM

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 · November 22, 2017 9:08PM

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 · November 17, 2017 4:59PM

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 · November 17, 2017 5:03PM

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

Invalid Objects or future enhancement

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk