Enhanced scroll bar

A further improvement that will be used on a much more regular basis is the enhanced scroll bar in the T-SQL editor tab. In the following screenshot, we can see an example of a T-SQL stored procedure that has been opened for editing:

SQL Server Management Studio scroll bar enhancements

The main points to pay attention to are: the margin on the left-hand side of the screen and the scroll bar on the right-hand side of Management Studio. The enhancement here allows us to easily identify a few details in our script window, namely:

  • Green blocks show changes made in the editor have been saved to the file currently being edited
  • Yellow blocks show changes that have not yet been saved
  • Red blocks show code that is invalid or has syntax errors (native IntelliSense must be enabled for this feature to work)
  • The blue marker on the scroll bar shows the location of the cursor

These subtle changes are further examples of the Visual Studio base providing us with further enhancements to make working inside SSMS easier. Knowing what code has been changed or is defective at a syntax level allows us to quickly navigate through our code inside SSMS.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.117.170.65