So I'm trying to trial this software but ctrl-e doesn't execute the SQL. I've used ctrl-e to execute SQL since SQL Server 6 now it goes into some kind of antique WordStar macro-mode?
How do I fix this lame behavior?
Ctrl-E doesn't execute SQL?
-
alexa
Re: Ctrl-E doesn't execute SQL?
Starting from SSMS2012, you can redefine the shortcut for the 'SQLComplete10.Common_ExecuteCurrentStatement' command in the 'Environment -> Keyboard' section of the 'Options' window that can be invoked by selecting 'Tools -> Options' from the main menu.
Re: Ctrl-E doesn't execute SQL?
Let me clarify. ctrl-e is working as expected in SSMS 2012 and 2014 for me. It's the trial for dbForge that has the WordStar behavior for me.
I don't see any commands called 'SQLComplete10.Common_ExecuteCurrentStatement' in Environment > Keyboard in dbForge.
I do have the SQL Server Management Studio mapping scheme applied, but when I press Ctrl-E in the box to assign it, I see several mapping that start with that keypress followed by a 2nd keypress. Query Builder has it defined to Sql.Execute, but that's evidently correct.
I don't see any commands called 'SQLComplete10.Common_ExecuteCurrentStatement' in Environment > Keyboard in dbForge.
I do have the SQL Server Management Studio mapping scheme applied, but when I press Ctrl-E in the box to assign it, I see several mapping that start with that keypress followed by a 2nd keypress. Query Builder has it defined to Sql.Execute, but that's evidently correct.
-
alexa
Re: Ctrl-E doesn't execute SQL?
The mentioned instructions were for another our product dbForge SQL Complete https://www.devart.com/dbforge/sql/sqlc ... nload.html
In case you are referring to dbForge Studio for SQL Server, please perform the following:
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Keyboard' branch.
3. Type 'Sql.ExecuteCurrent' in the 'Show Commands Containing' field.
4. Select the found 'Sql.ExecuteCurrent' command in the list below.
5. In the 'Use new shortcut in' field, select 'Text Editor'.
6. Set the focus in the 'Press shortcut keys' field and press the required key combination.
7. Click the 'Assign' button.
8. Click 'OK'.
In case you are referring to dbForge Studio for SQL Server, please perform the following:
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Keyboard' branch.
3. Type 'Sql.ExecuteCurrent' in the 'Show Commands Containing' field.
4. Select the found 'Sql.ExecuteCurrent' command in the list below.
5. In the 'Use new shortcut in' field, select 'Text Editor'.
6. Set the focus in the 'Press shortcut keys' field and press the required key combination.
7. Click the 'Assign' button.
8. Click 'OK'.