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