question

thatismatt avatar image
thatismatt asked

SSMS Shortcut Keys

What is your favourite shortcut key for SSMS?

One shortcut per answer please

ssmssubjectiveshortcut-keykeyboardkeystroke
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Excellent question.
0 Likes 0 ·
Steve Jones - Editor avatar image
Steve Jones - Editor answered

ALT+X to execute batches, but I am trying to move to CTRL+E

However CTRL+K, CTRL+U or CTRL+K, CTRL+C for commenting/uncommenting are way up there for me as well.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

thatismatt avatar image
thatismatt answered

Ctrl + N - New Query

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jay Bonk avatar image
Jay Bonk answered

Ctrl + R to close the results window

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered

CTRL + E to execute procedures.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

OK I know the question said SSMS, but EM + QA was the 'old' SSMS!

Prior to SQL2005 CTRL + B would grab focus of the divide line between query editor window and results window, and you could move it up and down with cursor keys. Still miss it!

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jesse McLain avatar image
Jesse McLain answered

The one I use the most is F8, to open the Object Explorer. I think it should be modified so that if it opens in "pinned" mode, pressing F8 again will close it.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Raj More avatar image
Raj More answered

At the end of the day I love ALT F4

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Raj More avatar image
Raj More answered

Cycle between windows

CTRL TAB

CTRL SHIFT TAB

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Raj More avatar image
Raj More answered

for Solution Explorer CTRLALTL

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Raj More avatar image
Raj More answered

Save Save Save (even if there's auto-save ON, please save)

CONTROL S

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.