Invalid Objects

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Invalid Objects

Postby rajeshckr » Wed Mar 26, 2014 1:49 pm

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
 
Posts: 2
Joined: Wed Mar 26, 2014 1:44 pm

Postby Anu Deshpande » Thu Mar 27, 2014 3:00 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Invalid Objects

Postby rajeshckr » Thu Mar 27, 2014 3:13 pm

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
 
Posts: 2
Joined: Wed Mar 26, 2014 1:44 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests