During my evaluation of SQL Server 2014, I happened to face a problem, when I hit the F5 key in the Object Explorer, the SSMS was starting the Debug action instead of Refresh.
Usually most of them will be happy for F5=Refresh and F5=Query Execution.
Here is the procedure to Re-assign F5 key to refresh action in SQL Server Management Studio.
Usually most of them will be happy for F5=Refresh and F5=Query Execution.
Here is the procedure to Re-assign F5 key to refresh action in SQL Server Management Studio.
- Open Management Studio
- Go to Tools >> Options
- Expand Environment >> Keyboard >> Keyboard
- In the "Show commands containing:", type "View.Refresh" and here you can observe that "Shortcuts for selected command:" will be grayed out
- Now choose "Global" in the "Use new shortcut in:" and press F5 button in "Press shortcut keys:"
- Click Assign
- Click Ok
From now on, when you press F5 in the Object explorer, the window will be refreshed instead of initiating debug option.
That was worth reading blog. Thanks for sharing.
ReplyDeletealso, join SQL course in Pune