Bug in finding invalid objects

scollis

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

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,

scollis

Yes, it's SQL Prompt 6.5.0.330

Anu D

This post is created to merge the SQL Prompt topic which was created in Source control forum instead of Prompt forums

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,

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!