Opening The SQL Server Management Studio From The Command Line

 

Here you will find information on how to start the SQL Server Management Studio (SSMS) from a shortcut or from the command line.

 

The following will open the SSMS by using Windows Authentication and will bypass the splash screen. The query editor will be set to the SMS_XXX database:

 

SqlWb -E -S SQLServerName -d SMS_XXX –NoSplash

 

Note: Change SQLServerName as needed.

 

SqlWb Arguments:

 

SqlWb (Options)

 

Scriptfile Specifies one or more script files to open.

Projectfile Specifies a script project to open.

Solutionfile Specifies a solution to open.

 

-S Server Name

-d Database Name

-U Username

-P Password

-E Windows Authentication

-Nosplash Bypasses the splash screen

 -? Help

 

 

 

Published Monday, May 26, 2008 7:38 AM by dhite

Comments

No Comments