How is SQL Prompt helping your team? Share your experience.
SQL Prompt Shift + F5 Issue
vsha041 Posts: 6 New member
edited December 21, 2015 2:39PM in SQL Prompt
I just installed Red Gate SQL Prompt and Shift + F5 does not work at all. If I right click the line and then select "execute current statement" then it works. I am using Windows 10 , SQL Server Version 12.0.2000.8 (2014) and the SQL Prompt version is 184.108.40.206. Is that a known issue? If yes then what needs to be done from my side?
0 · Share on Twitter
Iâ€™m sorry to hear that youâ€™re having trouble with this feature. Iâ€™ve tried to reproduce the issue on an identical set up to yours but the problem isnâ€™t occurring for me. There are a few things that could be going on here:
Just to check before we go any further, is the caret inside the block you want to execute before you press Shift+F5? (see this video for more information: https://youtu.be/BqHZ4wqh_Ko?t=40 ).
Itâ€™s possible that something else has bound to this keyboard shortcut. To find out whether this is the case, inside SSMS go to Tools > Options > Keyboard and filter the commands list by â€˜ExecuteCurrentStatementâ€™. Is the shortcut for the 'RedGate.SQLPrompt.SSMSUI.Connect2011.ExecuteCurrentStatement' command â€˜Shift+F5 (SQL Query Editor)' ?
If the shortcut is different you can manually change this shortcut back to Shift+F5 which should fix the problem. After restarting SSMS, the shortcut may revert to whatever had stolen it in the first place. If this is the case then we can make a configuration change to force SQL Prompt to rebind its shortcuts on start up.
If the shortcut in the Options window is not different then can you see the 'Shift+F5' key binding list next the context menu item for Execute Current Statement when you right click on a statement?