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.
1 comment:
That was worth reading blog. Thanks for sharing.
also, join SQL course in Pune
Post a Comment