Invalid Objects - Three questions

meklembl

What object types are searched?

At this time which are not searched and why not?

When the tool begins there is a counter that appears, but try as I might, I can not formulate a query that matches the number that the tool gets. Can you post that query and can you put the number of objects searched above the results. Such as "100 results found in DATABASENAME. 2300 objects searched."

Thanks,
Larry M
Cleveland, OH USA

Anu D

Many thanks for your post.

1. It looks for all invalid objects.Objects are listed as invalid by SQL Prompt if they:

a) cannot be compiled
b) can be compiled, but cannot be executed
For example, a stored procedure that references an object that no longer exists in the database is listed as invalid.

2. I am bit confused by this question. Did you had an invalid object that was not searched by SQL prompt --> Invalid Object functionality?

3. Which query are you referring to? Can you please email me the screenshot by replying to my email?