It is used to start SQL Server Management Studio from a command prompt.This is an executable file SSMS.Exe Write SSMS on the Run Window.
SSMS
For More details use:- SSMS/? We can directly open SQL Server Management Studio.
Here are the following options in SSMS
[-S]- Server name
Example : SSMS -s ServerName
[-U]- username
Example: SSMS -s ServerName -U username
[-P]- password
Example: SSMS -s ServerName -U username -P Password
[-d]- Database name
Example: SSMS -s ServerName -d Database Name -U username -P Password
- nosplash
Without showing the splash screen -nosplash. It Prevents opening SQL Server Management Studio.
[-E]: It is used to open with Windows Authentication.
[scriptfile] Ssms "DriveName:\ScriptsFiles\EndQuery.sql"
[projectfile] Ssms "\\Project\NewProj.ssmssqlproj"
[solutionfile] Ssms "DriveName:\solutions\YearReport.ssmssln"