What are the challenges you face when working across database platforms? Take the survey

Invalid Objects - Three questions

meklemblmeklembl Posts: 107 Bronze 2
edited May 19, 2011 5:35AM in SQL Prompt Previous Versions
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."

Larry M
Cleveland, OH USA
Larry M
Cleveland, OH USA


  • Options
    Anu DAnu D Posts: 876 Silver 3
    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?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.