Home / server / Questions / 394279
Accepted
Phil Hannent
Asked: 2012-06-01 01:36:56 +0800 CST

Is there a way of setting up a shortcut to a database for MS SQL Server Management Studio

  • 772

I'd like to have a list of my database servers (I am a developer), I currently have a list of RDP files for different machines I connect to. Is there a similar feature in SQL Server Management Studio that would help me go directly to where I need to go without me having to wait for the login screen to pop up and ask me which server I want?

ssms shortcut

1 Answers

  1. Best Answer

    Yes you can use the following command:

    ssms.exe -S SERVERNAME -d DATABASENAME -E

    You can either run this using run, or put it into a .txt file and change the extension to .bat and run that.

    Some more information can be found by runing smss.exe /?:

    Usage:
ssms.exe [-S server_name[\instance_name]] [-d database] [-U user] [-P password] [-E] [file_name[, file_name]] [/?]

    [-S The name of the SQL Server instance to which to connect]
    [-d The name of the SQL Server database to which to connect]
    [-E]    Use Windows Authentication to login to SQL Server
    [-U The name of the SQL Server login with which to connect]
    [-P The password associated with the login]
    [file_name[, file_name]] names of files to load
    [-nosplash] Supress splash screen
    [/?]    Displays this usage information
    • 7