cannot format sql statement

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

cannot format sql statement

Postby qinking126 » Sat Jun 30, 2012 9:47 pm

I am using sql server 2008 r2 and have sql prompt5 installed. format sql (crtl+K, ctrl+Y) is disabled from the menu. I clicked on the "new query" in the sql server management studio, wrote down some queries, format sql still disabled.

I see this message at the bottom of my management studio.
The key combination (ctrl+K, ctrl+Y) is bound to command (RedGate.SqlPrompt.SSMSUI.LayoutSQL) which is not currently available.

how should I enable it?
qinking126
 
Posts: 1
Joined: Sat Jun 30, 2012 9:41 pm

Postby stanori » Mon Jul 02, 2012 4:35 pm

Hi qinking126,

The "format sql" feature in SQL Prompt is part of the "Pro" version of SQL Prompt. In the SQL Prompt menu, you will notice a ribbon next to it, which is used to denote our Pro features.

To get this feature, you will need to upgrade to the Pro version. Please see the following feature matrix:

http://www.red-gate.com/products/sql-de ... ure-matrix

Best Regards,
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
stanori
 
Posts: 84
Joined: Mon Apr 23, 2012 1:13 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests