Comments
Sort by recent activity
So, have you noticed the new menu item at the top of the SQL Prompt menu in version 5.2.0.5? [image] / comments
So, have you noticed the new menu item at the top of the SQL Prompt menu in version 5.2.0.5?
You can disable Prompt's intellisense via the SQL Prompt Options dialog. From the SQL Prompt 5 menu, select 'Options...', and then in the Main->Behaviour page, uncheck 'Use SQL Prompt'. Slightly less drastic than uninstalling Prompt altogether!
Oh, and I might have some even better news for you soon - watch out for the next release candidate... [image] / comments
You can disable Prompt's intellisense via the SQL Prompt Options dialog. From the SQL Prompt 5 menu, select 'Options...', and then in the Main->Behaviour page, uncheck 'Use SQL Prompt'. Slightly le...
I'm afraid that there isn't any way of doing that at the moment.
However, we have made some performance improvements in Prompt's processing of complex scripts in recent builds. Have you tried using the latest release version, 5.1.8.2? / comments
I'm afraid that there isn't any way of doing that at the moment.
However, we have made some performance improvements in Prompt's processing of complex scripts in recent builds. Have you tried using...
If you upgrade to SQL Prompt 5.2.0.5, you should find that both of these problems (missing keyboard shortcuts and incompatibility with Tab Magic) have both been resolved.
You can upgrade using SQL Prompt's 'Check For Updates' feature. / comments
If you upgrade to SQL Prompt 5.2.0.5, you should find that both of these problems (missing keyboard shortcuts and incompatibility with Tab Magic) have both been resolved.
You can upgrade using SQL ...
That's very strange. It implies that SQL Prompt hasn't managed to attach to the query window you're working with.
Is there anything in the SQL Prompt log? (SQL Prompt 5->Help->Show Log) / comments
That's very strange. It implies that SQL Prompt hasn't managed to attach to the query window you're working with.
Is there anything in the SQL Prompt log? (SQL Prompt 5->Help->Show Log)
Hi sqlninja,
I'm very sorry to hear that. Could you give me a bit more detail about what's happening?
Mike / comments
Hi sqlninja,
I'm very sorry to hear that. Could you give me a bit more detail about what's happening?
Mike
I'm glad that I've found a solution for you, but I'm still trying to get to the bottom of why this happens to some people. It would be really helpful if anybody who's had this problem could post the following information to this thread:
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! / comments
I'm glad that I've found a solution for you, but I'm still trying to get to the bottom of why this happens to some people. It would be really helpful if anybody who's had this problem could post th...
I've also retried with Prompt version 5.1.92.8 as mentioned in previous posts, and still can't reproduce the problem.
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:
"%ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\binn\VSShell\Common7\IDE\Ssms.exe" /setup
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). / comments
I've also retried with Prompt version 5.1.92.8 as mentioned in previous posts, and still can't reproduce the problem.
Do any of you have any other addins installed in SSMS?
There's one thing that m...
I'm afraid I've been unable to reproduce this problem using SSMS 2008 R2, trying with both Windows 7 32 bit and Windows 7 64 bit.
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:
Launch SSMS 2008 R2
Connect to a database
Click on the SQL Prompt 5 menu (without a query window open) and check that the keyboard shortcuts are NOT available
Press 'New Query' on the toolbar to open a query window
Click on the SQL Prompt 5 menu to check that all keyboard shortcuts are now displayed
Cancel the menu, then type a simple query in the editor window (e.g. SELECT * FROM...)
Press CTRL+K,Y to format. Also tried using Ctrl+B,L
Can you think of anything that might be special in your cases that I haven't considered? / comments
I'm afraid I've been unable to reproduce this problem using SSMS 2008 R2, trying with both Windows 7 32 bit and Windows 7 64 bit.
I've tried using a clean install of SQL Prompt 5.1.94.2, and also u...
Thanks for reporting that. I'll investigate further using SSMS 2008R2 / comments
Thanks for reporting that. I'll investigate further using SSMS 2008R2