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

Bug in finding invalid objects

Just doing a scan for invalid objects. There are 1,545 to check, and it gets to 980 and stops with "Login failed".

Now probably that is the cause of my problem, in that the object it's trying to check nobody has permissions on. However because of that login failed, I can't see which object is causing the problem.

Can we have a fix so that if it gets a login problem hitting a specific object, it will report that as being the reason for the object being invalid, rather than stopping with a login problem screen which (in this case) is somewhat less than helpful?

Ta muchly :)
Simon Collis
0

Comments

5 comments

Sort by
  • Sergio R
    Hi zippy72,

    So that I can be sure we're on the same wavelength are you using the Find Invalid Objects feature in SQL Prompt?

    Thank you,
    Sergio R
    0
  • scollis
    Yes, it's SQL Prompt 6.5.0.330
    scollis
    0
  • Anu D
    This post is created to merge the SQL Prompt topic which was created in Source control forum instead of Prompt forums
    Anu D
    0
  • Sergio R
    Hi zippy72,

    I am unsure at this moment whether this is a bug as I have been unable to replicate it in our lab.
    I will get in touch with you through our support system to get more details to better assess the situation.

    Thank you,
    Sergio R
    0
  • scollis
    Hi Sergio,

    I didn't get a "report this error" box - usually I use that and don't bother with anything else. In this case, I didn't.

    I was going to record you a video so you could see the behaviour - and today, it's working. So something has changed with the new version (I'm on frequent updates and can't remember when the last one was) or something has changed with the security settings on the database.

    Either way, you might as well close this one off and if I get it again I'll record a video so you can see the behaviour.

    Thanks for your help! :)
    scollis
    0

Add comment

Please sign in to leave a comment.