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


No Comments