Managed Stored Procedures Not In Suggestions

Provides intelligent code completion for SQL Server editors.

Managed Stored Procedures Not In Suggestions

Postby bfox » Fri Oct 08, 2010 2:23 pm

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!
Posts: 6
Joined: Tue Aug 22, 2006 6:47 pm

Managed Stored Procedures not in suggestions

Postby dsp » Sat Oct 09, 2010 9:35 pm

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 :(
Posts: 17
Joined: Sat Jan 30, 2010 6:46 pm

CLR functions

Postby jermy » Thu Nov 11, 2010 3:52 pm


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?

Posts: 9
Joined: Tue Mar 16, 2010 6:56 pm

Postby Luke Jefferson » Mon Nov 15, 2010 11:22 am


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
Posts: 33
Joined: Fri Sep 17, 2010 9:26 am

Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 1 guest