Invalid Objects

rajeshckrrajeshckr Posts: 3
edited March 27, 2014 10:13AM in SQL Prompt Previous Versions
I run 5.3.8.2.

When I try find invalid objects, it does not find any of them. I do have few stored procedures that are getting called from other SPs with incorrect number of parameters and it certainly fails on execution.

Am I missing something? I tried restaring SSMS multiple times too.

Raj

Comments

  • Thanks for your post.

    Objects are listed as invalid by SQL Prompt if they:
    - cannot be compiled
    - 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.

    Hope this answers your question.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • In this case it indeed does not compile (since this SP refers to another SP which now takes less number of arguments)

    So it should come as a part of invalid objects right?
Sign In or Register to comment.