Managed Stored Procedures Not In Suggestions

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

Managed Stored Procedures Not In Suggestions

Postby bfox » Fri Oct 08, 2010 3: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!
bfox
 
Posts: 6
Joined: Tue Aug 22, 2006 7:47 pm

Managed Stored Procedures not in suggestions

Postby dsp » Sat Oct 09, 2010 10: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 :(
dsp
 
Posts: 17
Joined: Sat Jan 30, 2010 7:46 pm

CLR functions

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

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
 
Posts: 9
Joined: Tue Mar 16, 2010 7:56 pm

Postby Luke Jefferson » Mon Nov 15, 2010 12:22 pm

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


Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests

cron