Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Ssms Utility

TheSsms utility opens SQL Server Management Studio. If specified, Ssms also establishes a connection to a server, and opens queries, scripts, files, projects, and solutions.

You can specify files that contain queries, projects, or solutions. Files that contain queries are automatically connected to a server if connection information is provided and the file type is associated with that type of server. For instance, .sql files will open a SQL Query Editor window in SQL Server Management Studio, and .mdx files will open an MDX Query Editor window in SQL Server Management Studio. SQL Server Solutions and Projects will open in SQL Server Management Studio.

NoteNote

TheSsms utility does not run queries. To run queries from the command line, use the sqlcmd utility.


Ssms
    [scriptfile] [projectfile] [solutionfile]
    [-S servername] [-d databasename] [-U username] [-P password] 
    [-E] [-nosplash] [-?]
scriptfile

Specifies one or more script files to open. The parameter must contain the full path to the files.

projectfile

Specifies a script project to open. The parameter must contain the full path to the script project file.

solutionfile

Specifies a solution to open. The parameter must contain the full path to the solution file.

[-Sservername]

Server name

[-ddatabasename]

Database name

[-U username]

User name when connecting with SQL Server Authentication

[-Ppassword]

Password when connecting with SQL Server Authentication

[-E]

Connect using Windows Authentication

-nosplash

Prevents SQL Server Management Studio from displaying the splash screen graphic while opening. Use this option when connecting to the computer running SQL Server Management Studio by means of Terminal Services over a connection with a limited bandwidth. This argument is not case-sensitive and may appear before or after other arguments

[-?]

Displays command line help

All of the switches are optional and separated by a space except files which are separated by commas. If you do not specify any switches, Ssms opens SQL Server Management Studio as specified in the Options settings on the Tools menu. For example, if the Environment/General page At startup option specifies Open new query window, Ssms will open with a blank Query Editor.

Files that contain queries will prompt to be connected to a server if connection information is provided and the file type is associated with that type of server. For instance, .sql files will open a SQL Query Editor window in SQL Server Management Studio, and .mdx files will open an MDX Query Editor window in SQL Server Management Studio. SQL Server Solutions and Projects will open in SQL Server Management Studio.

The following table maps server types to file extensions.

Server type

Extension

SQL Server

.sql

SQL Server Compact 3.5 SP2

.sqlce

SQL Server Analysis Services

.mdx

.xmla

NoteNote

SQL Server Management Studio does not support SQL Server Compact 4.0.

The following script opens SQL Server Management Studio from a command prompt with the default settings:

sqlwb

The following script opens SQL Server Management Studio from a command prompt, with Windows Authentication, with the Code Editor set to the server ACCTG and the database AdventureWorks2008R2, without showing the splash screen:

Ssms -E -S ACCTG -d AdventureWorks2008R2 -nosplash

The following script opens SQL Server Management Studio from a command prompt, and opens the MonthEndQuery script.

Ssms "C:\Documents and Settings\username\My Documents\SQL Server Management Studio Projects\FinanceScripts\FinanceScripts\MonthEndQuery.sql"

The following script opens SQL Server Management Studio from a command prompt, and opens the NewReportsProject project on the computer named developer:

Ssms "\\developer\fin\ReportProj\ReportProj\NewReportProj.ssmssqlproj"

The following script opens SQL Server Management Studio from a command prompt, and opens the MonthlyReports solution:

Ssms "C:\solutionsfolder\ReportProj\MonthlyReports.ssmssln"

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.