Login failed when attempting to find invalid objects in (Database)...

Rog

Hello,

I keep getting this error when trying to run the "Find Invalid Objects" functionality:

Login failed when attempting to find invalid objects in <database>.
To find invalid objects, your user must have:
• access to the database
• the VIEW DEFINITION permission granted on the database

How do I get past this error?

Thanks!

AlessandroAlpi

hi @Rog,
does this happen on all the objects you check?

Rog

AlessandroAlpi wrote: »

hi @Rog,
does this happen on all the objects you check?

This is happening when I run it on a database and it's breaking at the same place, but it doesn't tell me which object is causing the problem.

Is there a way I can run this on specific objects instead of an entire database?

Thanks,
Rog

AlessandroAlpi

Rog wrote: »

Is there a way I can run this on specific objects instead of an entire database?

you're right, I confused that feature with "find unused items" in scripts.
You mentioned "it's breaking at the same place", which is? Right after the click?
In order to understand better, you could trace the commands using SQL Profiler. It could be some trouble in your user's permission set.