cannot format sql statement

Provides intelligent code completion for SQL Server editors.

cannot format sql statement

Postby qinking126 » Sat Jun 30, 2012 8: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?
Posts: 1
Joined: Sat Jun 30, 2012 8:41 pm

Postby stanori » Mon Jul 02, 2012 3: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: ... ure-matrix

Best Regards,
Steve Tanori
Product Support
Red Gate Software Ltd.
Posts: 84
Joined: Mon Apr 23, 2012 12:13 pm

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests