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

Missing support for system stored procedures

Hello,

I tried to type in EXEC sp_help. I noticed that I had to activate something in the options to have it in the candidate list. But then I would definitely love to have some support about the arguments of the SP. Maybe a list of arguments as a comment on the next line? Definetely missing...

I had the impression it showed up somewhere else, but I've been unable to reproduce it with sp_help....

With kind regards,

Emmanuel
nanchen
0

Comments

3 comments

Sort by
  • Tilman
    Hi,

    I think what you are encountering is the problem that we can't get information about parameters of system stored procedures in SQL Server 2005. I.e. when I do

    exec sp_help

    in SQL Server 2005 I don't get parameters, in SQL Server 2000 I do.

    I'm afraid that is a limitation we can't get round at the moment.

    Regards,

    Tilman
    Tilman
    0
  • nanchen
    Yes, I am targeting a SQL 2005 instance.

    Thanks for your input,

    Emmanuel
    nanchen
    0
  • Bart Read
    Hi Emmanuel,


    You'll find a more detailed discussion of this topic in this thread posted by Adam Machanic. As you'll see from my final post things are not quite what they seem at first:

    http://www.red-gate.com/MessageBoard/vi ... php?t=3893

    So the information is actually available, but for whatever reason our meta-data model doesn't pull it out. I'm going to have to wait until the New Year to find out what the story is here.


    Thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.