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

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

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!
Rog
0

Comments

3 comments

Sort by
  • AlessandroAlpi
    hi @Rog,
    does this happen on all the objects you check?
    AlessandroAlpi
    0
  • Rog
    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
    Rog
    0
  • 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.
    AlessandroAlpi
    0

Add comment

Please sign in to leave a comment.