#Ms sql studio 2016 update#

You can also scroll the content of the window by dragging the content with mouse.ħ. Now you can zoom the content of this window using shortcut CTRL + Scroll. There are also few improvements done on the Execution Plan window. Tools - Options - Text Editor - General - “ Highlight current line” That makes it easy to identify the line you are currently working with. Now, with SSMS 2016, an outline will follow your cursor wherever you placed it. How many times do you feel lost while modifying an existing huge query or stored procedure in SSMS? The problem occurs when your SQL statements are very long and you haven’t configured text editor to wrap words automatically and then when you use the horizontal scrollbar to scroll the content, it becomes difficult to identify which line you wanted to modify or check. You can search with the feature name or a keyword. You can disable automatic checking for updates by unchecking the checkbox in the popup window that appears when you click ' Check for Updates.' as described above.Ĭonfused with so many new features and steps to open the window to configure them? Don’t worry, SSMS now has the Search Options which is one of much requested feature. However, you can also check manually for updates availability.

#Ms sql studio 2016 update#

SSMS 2016 automatically checks for any updates available when it is online and a toast notification comes when there is an update available something as following screenshot. Tools - Options - Query Execution - SQL Server - General - “ Prompt to save unsaved T-SQL query windows on close” While this restriction is actually meaningful to have in SSMS, with SSMS 2016, you can now customize to hide those prompts as per your preference. In earlier versions of SSMS, you can’t ignore the save query windows prompt that comes when you want to close either an unsaved query window or the SSMS itself.

Tools - Options - Environment - General - Color theme For now, you can choose one from 2 available color themes – Blue or Light, Blue being the default theme. With SSMS 2016, now you can choose your preferred color theme, a feature similar to that in Visual Studio.