CODEWITHSUNDEEP
sql-server-2005ssms
Michael Kniskern
Michael Kniskern

Reputation: 25270

Keyboard shortcut for "Connect to Server" in Management Studio

Is there a keyboard shortcut for the "Connect to Server" modal window in Microsoft SQL Server Server Management Studio?

The modal window that is displayed when you first opened up SQL Server Management Studio from the Start Menu or shortcut.

Upvotes: 11

Views: 12671

Answers (5)

Ric
Ric

Reputation: 1

This is a good muscle-memory series: ALT+QCH

Upvotes: 0

Ashley Bickerstaffe
Ashley Bickerstaffe

Reputation: 81

Open a query in SSMS. In the menu bar, select Tools -> Options -> Keyboard (Under the Environment node)

Screenshot

Within the Press Shortcut Keys – Press the key you would like to assign to the shortcut to. In my case I have used F2. Within the commands box highlight Query.ChangeConnection and click on assign. This will now open up the SQL Server connection window on pressing F2.

https://ashleybickerstaffe.wordpress.com/2016/05/04/change-sql-server-management-studio-ssms-connection-keyboard-shortcut/

Upvotes: 8

Amjad
Amjad

Reputation: 411

Another way is to create a shortcut. For instance I use: Ctrl+K,Ctrl+O for this purpose.

  1. TOOLS > OPTIONS
  2. ENVIRONMENT > KEYBOARD > KEYBOARD
  3. Write in Show Commands containing: Query.ChangeConnection
  4. Press shortcut keys (which is currently not used by any other action)

Upvotes: 21

haku
haku

Reputation: 4505

only for ssms 2012

One work around that I found is to customize the listing of options on 'Query' menu bar and move the 'Change Connection...' option to the top under 'Query|Connection'. Once that is done, the keyboard shortcut would be,

'Alt' + 'Q', 'Right Arrow Key' then 'Enter key'.

Btw, to customize 'Query' to move 'Change Connection...' to the top:

  1. right click on 'Change Connection' icon
  2. Select 'Customize...'
  3. Select 'Commands' tab
  4. Select 'Query|Connection' from the 'Menu Bar' drop down
  5. Select 'Change Connection...' options in the 'Controls:' box and move it to the top.

Now, 'Alt' + 'Q', 'Right Arrow Key' then 'Enter key'. is ready to use. Without the customization, the shortcut would be 'Alt' + 'Q', 'Right Arrow Key', 'Up arrow key' then 'Enter key'.

Btw, to connect to object explorer, Alt + F, E works.

Upvotes: 1

Michael Kniskern
Michael Kniskern

Reputation: 25270

F8 (Object Explorer), Alt + F (File Menu), E (Connect Object Explorer)

Upvotes: 12

Related Questions