SQL Prompt 5 second early access release

Provides intelligent code completion for SQL Server editors.

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

SQL Prompt 5 second early access release

Postby Paul Stephenson » Wed Sep 22, 2010 9:54 am

The second early access release of SQL Prompt 5 is now ready for you to try.

What’s new?
In addition to features in the first early access release, this new release introduces:
  • Column Dependencies
  • Find Unused Variables and Parameters (introduced from SQL Refactor)
  • Encapsulate As New Stored Procedure (introduced from SQL Refactor)
  • Summarize Script (introduced from SQL Refactor)
For full details, including how to try out all these features, see What’s new in SQL Prompt 5?

Before you start
If you already have the first SQL Prompt 5 early access release installed, simply run the new installer to upgrade.

If you do not already have SQL Prompt 5 installed, please uninstall SQL Prompt 4 and SQL Refactor before trying the SQL Prompt 5 Early Access release.

How do I get the early access release?
Subscribe to the SQL Prompt early access mailing list and we’ll provide you with the download details.

Feedback
SQL Prompt 5 is still in development, and we value any feedback you may have; please let us know if you have any comments or suggestions.
If you find an error or bug with the early access release, please post a detailed description of the error here in the SQL Prompt 5 EAP forum.

What’s still to come?
We’re working on the following new features for further early access releases:
  • Find Invalid Objects
  • Qualify Object Names (from SQL Refactor)
  • Expand Wildcards (from SQL Refactor)

We look forward to your feedback,

Paul Stephenson
SQL Prompt Project Manager at Red Gate Software
Paul Stephenson
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Postby paschott » Wed Sep 29, 2010 4:43 am

Any news on a new release? The second EAP hangs my SSMS window on SQL 2008 R2 when I connect to a Server. With the first EAP having quit just now, I can't continue testing. I am not quite sure what to send or if there is anything to send at this time. Just know that this release doesn't work for me and I've seen some other posts here as well about problems with the second EAP.
paschott
 
Posts: 64
Joined: Wed May 10, 2006 4:10 pm

Postby fatherjack » Wed Sep 29, 2010 9:15 am

Paul, Where do we get the download? I have v5 installed and its currently ceased to prompt so need to either get the new EAP or revert to v4 soon
-----------------------------------------
Senior DBA
Careers South West Ltd
fatherjack
 
Posts: 224
Joined: Tue Mar 13, 2007 12:33 pm
Location: Cornwall

Postby Paul Stephenson » Wed Sep 29, 2010 1:07 pm

paschott: I've sent you a private email.

fatherjack: I've sent you the location of the second Early Access release.

Regards,
Paul Stephenson
SQL Prompt Project Manager
Red Gate Software
Paul Stephenson
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Postby markv » Wed Sep 29, 2010 1:54 pm

I have found the same hang with SSMS 2008 R2. What I found cured this was to cancel the initial connection dialog and then try to connect. All appears to be OK from then on.

You can make this the default in SSMS 2008 by going to Tools -> Options and set it to open an empty environment at startup.
markv
 
Posts: 14
Joined: Tue Jul 06, 2010 4:47 pm

Postby paschott » Wed Sep 29, 2010 4:15 pm

@markv - sadly that didn't work for me - tried it last night. :) Rolled back to v4 afterwards and was pleasantly surprised to find that my snippets from that version were still intact.

@Paul - shot you a message back, though I realize it's pretty late already if you're in the UK office. I'm running on v4 for now so have some time.
paschott
 
Posts: 64
Joined: Wed May 10, 2006 4:10 pm

Postby jarrod268 » Wed Sep 29, 2010 4:57 pm

May I have the download location? Just got directed here via twitter :)
jarrod268
 
Posts: 1
Joined: Wed Sep 29, 2010 4:54 pm

Postby markv » Wed Sep 29, 2010 5:15 pm

I may not close my SSMS window for a long time then ;)
markv
 
Posts: 14
Joined: Tue Jul 06, 2010 4:47 pm

Re:

Postby David Atkinson » Wed Sep 29, 2010 6:35 pm

jarrod268 wrote:May I have the download location? Just got directed here via twitter :)

Hi,

To get the download location you are required to sign up to the SQL Prompt Early Access. This allows us to easily update you when there's a new version for you to try.

Kind regards,

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby markv » Mon Oct 11, 2010 3:22 pm

I have finally given up on SQL Prompt 5 too... it was just cause too many issues with locking up the SSMS at random times. Today's was that I was browsing through my tables and went to right click... then nothing else worked and SSMS even disappear from the taskbar though it was actually still running when you alt-tab'd!
markv
 
Posts: 14
Joined: Tue Jul 06, 2010 4:47 pm

Postby fatherjack » Mon Oct 11, 2010 4:10 pm

Wow, not seen any problems like that.

There are a few niggles with prompting getting in the way of typing - I think functions should rank over column names so typing object should give Object_id at top rather than expanding to objectid from a dmv ... and I still think that no aliases should be the same as snippet shortcuts. IE if I have a table called InternsJunior its alias should be InJ not IJ as IJ expands to Inner Join as soon as you tab on...
-----------------------------------------
Senior DBA
Careers South West Ltd
fatherjack
 
Posts: 224
Joined: Tue Mar 13, 2007 12:33 pm
Location: Cornwall

Postby paulo.morgado » Tue Oct 12, 2010 11:51 am

I'll have to uninstall it too.

Since yesterday I can't use SSMS because it hangs connecting to any server.
Paulo Morgado
Portugal
Web Site
Weblog
Twitter
paulo.morgado
 
Posts: 52
Joined: Wed Aug 16, 2006 3:41 pm
Location: Portugal

Postby Paul Stephenson » Fri Oct 15, 2010 2:54 pm

For those experiencing problems with the second early access release of SQL Prompt 5, could you try the third early access release and post how you get on?

We have fixed a number of bugs so it would be good to get feedback on any issues that remain.

Thanks,
Paul Stephenson
SQL Project Project Manager
Red Gate Software
Paul Stephenson
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK


Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 1 guest