Skip to content

Latest commit

 

History

History
39 lines (20 loc) · 1.53 KB

clickops-checklist.md

File metadata and controls

39 lines (20 loc) · 1.53 KB

SSMS Manual Config

The following options are client config I do not currently know how to set from either registry or .vssettings. Set them from the GUI for a new SSMS client config.

Retain CR/LF

Tools > Options | Query Results > SQL Server > Results to Grid | ✔️ "Retain CR/LF on copy of save"

Include column header

Tools > Options | Query Results > SQL Server > Results to Grid | ✔️ "Include column headers when copying or saving the results"

Lower case auto-complete

Tools > Options | Text Editor > Transact-SQL > Intellisense | Casing for built-in function names: > Lower case

Line Numbers

Tools > Options | Text Editor > Transact-SQL > General | ✔️ "Line Numbers

Empty environment on launch

Tools > Options | Environment > Startup | At startup: > Open empty environment

HT https://stackoverflow.com/a/16581591/4709762

Connection dialogue is blocking & will prevent RedGate SQL Prompt session reconnection in some circumstances AFAICT

Toggle Word Wrap quick option toggle

HT https://stackoverflow.com/a/47737665/4709762

Right Click Toolbar > Customize | Commands Tab > Choose "SQL Editor" in the 2nd Radio Button's Drop-down > Add Command > Toggle Word Wrap

In the "Add Command" interface, you can type to fast-scroll.

⚠️ DO NOT TRUST THE TOOL-TIP - the suggested hotkey appears to be inherited from Visual Studio but is overridden by the "Execute" command in SSMS.

Attempting to hotkey toggle word-wrap in this context is the equivalent of pressing F5