How can we help you today? How can we help you today?

Invalid Objects

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
rajeshckr
0

Comments

2 comments

Sort by
  • Anu D
    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.
    Anu D
    0
  • rajeshckr
    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?
    rajeshckr
    0

Add comment

Please sign in to leave a comment.