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

Managed Stored Procedures Not In Suggestions

I prefix all my managed stored procedures with msp (i.e. mspManagedSP). When I type EXEC m the suggestion list does not list any of the managed stored procedures. Am I doing something wrong or is this by design?

Thanks for your help!
bfox
0

Comments

3 comments

Sort by
  • dsp
    I asked this in January 2010 and received the following reply:

    Unfortunately SQL Prompt v4 does not yet support CLR types (including xml) and so it fails to prompt suggestions.

    I have logged this as a feature request in our internal tracking system whose id is SP-2866.

    It seems that this feature did not make it in the new release yet :(
    dsp
    0
  • jermy
    Hi,

    It also doesn't list CLR functions in the suggestions.
    I have an aggregate function using CLR which concatente strings delimited with commas and I use it quite frequently.
    Do you plan to add it?

    THNX
    Jermy
    jermy
    0
  • Luke Jefferson
    Hi,

    Unfortunately, we were unable to do any work on the parser in this release so support for CLR types (and XML) will not be in SQL Prompt 5.

    Luke Jefferson
    Product Manager
    Red Gate Software
    Luke Jefferson
    0

Add comment

Please sign in to leave a comment.