Tutorial :Keyboard shortcut for “Connect to Server” in Management Studio



Question:

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.


Solution:1

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)


Solution:2

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


Solution:3

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/


Solution:4

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.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »