What's with system stored procedures?

• 
  This works on my system just fine. You may need to go into SQL Prompt options on the Listed Candidates tab, Candidate Types and Filters, then check the Show: System Objects option in order to get them to show up.
  
  Hope this helps

  ikatsu December 03, 2007 20:16

  - 0 +
• 
  They do show up -- sometimes; and when they do, they only suggest user-defined functions or nothing at all.
  
  If I recall, sp_help works with more than just udf's.

  Dave Pendleton December 03, 2007 23:18

  - 0 +
• 

  Dave Pendleton wrote:

  They do show up -- sometimes; and when they do, they only suggest user-defined functions or nothing at all.
  
  If I recall, sp_help works with more than just udf's.

  
  Ah so the nature of the issue is that after you type sp_help the suggestion list is restricted to only showing functions instead of stored procedures, tables, and other supported objects. I have the same issue as you. It would seem that SqlPrompt is purposfully limiting itself in this case since most procedures do not allow for passing of procedure names as parameters.
  
  I would say that this would probably end up being a custom set of circumstances for items like sp_help, sp_helptext, sp_helpindex etc that would show specific object based on the stored procedure name instead of just a generic "Stored Procedure" acceptable list.
  
  Would be a nice enhancement request if you ask me.

  ikatsu December 05, 2007 17:49

  - 0 +

Add comment

Please sign in to leave a comment.