This website stores cookies on your computer.
These cookies are used to improve your website
experience and provide more personalized services
to you, both on this website and through other media.
To find out more about the cookies we use, see our
Privacy Policy
Comments
Can you please reply with the actions you have taken where the Format SQL feature is not working for you. Unfortunately I am unable to replicate your issue.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
After upgrading to the latest build, the keyboard shortcut (CTRL + k,y) for formatting text is gone.
The biggest change is that the key bindings now only apply in the SQL editor scope - i.e. they will only be available when a SQL Query editor tab has the focus. However, I wouldn't expect this to cause any problems, because the commands that the bindings apply to already only work when a SQL query tab is active.
A couple of questions:
1. Is it only the 'Format SQL' command that is affected, or have all the menu commands lost their key bindings?
2. Is there anything interesting in Prompt's logs (from the menu, select SQL Prompt 5 -> Help -> Show Log)? In particular, do any of the log entries mention 'bindings'?
Redgate Software
2. Nope.
I'm afraid I've got another question, but to make up for it, a possible workaround too.
Question: What version of SSMS are you using? [edit - apologies, I've just noticed that you told me the SSMS version in your first post :oops: ]
Potential workaround: There's a hidden keyboard shortcut for Format SQL, "Ctrl+B, Ctrl+L" which was added for backwards compatibility with previous versions of Prompt. You could try that shortcut and see if it works for you.
Redgate Software
Redgate Software
Thank's for verifying what's happening.
Gervais.
I've tried using a clean install of SQL Prompt 5.1.94.2, and also upgrades from 5.1.8.2 to 5.1.94.2, and directly from 5.1.6.35 to 5.1.94.2, and in all cases all the key bindings show up as expected.
The steps I'm carrying out are as follows:
Can you think of anything that might be special in your cases that I haven't considered?
Redgate Software
Running Win 7 64, Sql Management Studio 2008 R2 (10.50.2500.0), and Sql Prompt 5.1.94.2.
Very annoying.
Do any of you have any other addins installed in SSMS?
There's one thing that might help. Make sure SSMS is closed, then from a command prompt, run the following command:
Then restart SSMS.
If the problem still persists, it would be really helpful if one of you could post the contents of the SQL Prompt log straight after SSMS starts (from the SQL Prompt 5 menu, select Help->Show Log).
Redgate Software
I had Sql Prompt installed and licenced, I removed other tools that I already installed from Sql Server Belt that I do not used. At this point, I began to be not able to use the format SQL shortcut.
I remove all of Red Gate soft of my PC and re-install all the soft of Sql Server Belt, even those that I do not use.
SQL Promt sql format shortcuts works fine now!
Maybe it's something with installation-remove procedure.
Thank's.
Thanks
I am out of the office today so I will try the cmd tomorrow to see if that helps. I do have other add-ins installed such as SSMS Tools.
I ran the command above and it fixed the problem for me also. The short cut was missing from the menu and the CTRL B, CTRL L combo didnt' work either. now everything is fine.
I'm using Win XP 32 bit so I ran the command as below:
Im using SSMS version 10.50.1600.1
SQL prompt version: 5.1.94.2
- Version number of SQL Prompt that is exhibiting the missing shortcut problem
- Version of Prompt that was previously installed before upgrading to the problematic version
- Whether any commands other than Format SQL have been affected
- Version of SSMS in use
- Which other addins are installed in SSMS
- Operating system version and platform (e.g. Windows 7 64 bit)
Thanks for helping!Redgate Software
As a note, the command line fix didn't work for me. Still trying to find a solution.
[Edit: My bad. Forgot to run cmd as Administrator. It worked when I did that.]
Version number of SQL Prompt that is exhibiting the missing shortcut problem: 5.1.94.2
Version of Prompt that was previously installed before upgrading to the problematic version: unknown, but would have been the last distributed version
Whether any commands other than Format SQL have been affected: No, just this.
Version of SSMS in use: 10.50.2500.0
Which other addins are installed in SSMS: None
Operating system version and platform: Windows 7 (32 bit)
I'm very sorry to hear that. Could you give me a bit more detail about what's happening?
Mike
Redgate Software
Turn Off Prompting
Find invalid Objects
Options
Snippet Manager
Serial number
Provide Feedback
Help
And when type inside of SSMS, SQL Prompt is not "prompting", although I would like to note that the keyboard shortcut for formatting (ctrl + k,y) is showing in the menu again albeit greyed out.
Is there anything in the SQL Prompt log? (SQL Prompt 5->Help->Show Log)
Redgate Software
27 Oct 2011 16:45:00,092 [1] INFO RedGate.SqlPrompt.Engine.LogService - Starting new SQL Prompt editor session
But opening another tab "enabled" it, the tab I was on was reopened by tab magic, after closing SSMS to install the update.
Also, it now appears that formatting via the keyboard shortcut (ctrl + k,y) is working again...
Thanks
John
Working on a fix!
Software Engineer - SQL Prompt
Red Gate Software Ltd.
Here is the information of the software I am using
Microsoft SQL Server Management Studio 10.0.2531.0
Operating System 6.0.6002
SQL Prompt 5.1.94.2
Cleveland, OH USA
You can upgrade using SQL Prompt's 'Check For Updates' feature.
Redgate Software
Cleveland, OH USA