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

Invalid Objects

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

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.



  • Options
    Anu DAnu D Posts: 876 Silver 3
    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: support@red-gate.com
  • Options
    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.