Microsoft SSMS - Settings

Suggestion Settings: Short Version

SSMS Settings: More Detail

Line Numbers

Line Numbers

  • Text Editor
    • All Languages
      • General: Line numbers

Tab Text

Tab Text

  • Text Editor
    • Editor Tab and Status Bar
      • Tab Text
        • Include Database Name: False
        • Include File Name: True
        • Include Login Name: False
        • Include Server Name: False

This information is avaiable on the status bar at the bottom of the screen. If you routinely work between multiple databases, you may also wish to show the Database name in the tab.

Lower Case Built-In Function Names

Lower Case Built-In Function Names

  • Text Editor
    • Transact-SQL
      • IntelliSense
        • Casing for built-in function names: Lower case

Connection Dialog (SSMS21)

Lower Case Built-In Function Names

  • Environmen
    • Connection Dialog
      • SQL Server: (Classic or Modern)

Save Documents as UTF-8

Grid Results

  • Environment
    • Document
      • Save files with a specific encoding
        Unicode (UTF-8 without signature) - Code page 65001

Shortcut Key for Duplicate Line

Grid Results

  • Environment
    • Keyboard
      1. Show commmands containing: duplicate
      2. Select Edit.Duplicate
      3. Press shortcut keys: CtrlShiftD
      4. Assign

New Tab

New Tab

  • Environment
    • Tabs and Windows
      • Insert documents to the right of existing tabs

Fonts & Colours

The following can be a little flaky, as SSMS tends to forget the font settings. Later are instructions on importing from a setting file.

Text Editor

Grid Results

  • Environment

    • Fonts and Colors

  • Suggestions

    • Text Editor: Source Code Pro 18
    • Grid Results: Source Code Pro 12 [→ Restart]
    • Text Results: Source Code Pro 14 [→ Restart]

SSMS 21 also lets you change appearance of NULLs and the gridlines.

Copying Results

Copying Results

  • Query Results
    • SQL Server
      • Results to Grid
        • Include column headers when copying or saving the results

Create Template File

Install SSMSExecutor

Download SSMSExecutor

Download the SSMSExecutor Installer from:

https://github.com/manngo/ssms-executor-installer/releases/latest

You can get more information as well as alternative ways to install SSMSExecutor from:

https://github.com/manngo/ssms-executor-installer/

Right-Click on the Exe file and select Properties….

SSMSExecutor Installer Properties

Select Unblock.

Start the Installer

Start the SSMSExecutorInstaller.exe File. You will probably get the following warning:

Microsoft Defender Microsoft Defender Run Anyway

Run anyway …

Allow Changers

You’ll then be asked for permission to go ahead:

User Account Control

Obviously, select Yes

Install for your version of SSMS:

Start the SSMSExecutorInstaller.exe File. You will probably get the following warning:

Install SSMS Executor Install SSMS Executor OK

  • Any version of SSMS not installed in your system will appear with a question mark.
  • Any version of SSMS with SSMSExecutor already installed in your system will appear in bold.

Finished

All going well, you’ll see the following message.

Install SSMS Executor Successful

You can select OK and tehn Quit

Importing SSMS Settings

Tools | Import and Exporting Settings …

Import selected environment settings Next >

No, just import new settings … Next >

Browse for a Settings File Browse …

Highlight the Selected File Next >

Finish Finish

Close Close

Keyboard Shortcuts

Action Key
Execute F5
Show/Hide Results ⌃R
Refresh Database Cache ⌃⇧R
Results to Text ⌃T
Results to Grid ⌃D
Show Query Plan ⌃L
Show Object Explorer F8
Show Properties F4
Upper Case ⌃⇧U
Lower Case ⌃⇧L
Duplicate Line (See Above) ⌃⇧D