Friday, 11 January 2013

Easy way to Connect to SSMS through Command prompt


DBAs and Developers are normally using below steps to connect to SQL Server Management Studio.

1.   Start         ---- All Programs ---- Microsoft SQL Server 2012 ---- SQL Server Management Studio.
2.   Then Choose Windows Authentication or SQL Server Authentication.
3.   Provide User Name and Password and Click Connect.

It can be optimized by using command line parameters.

Let’s type below command to understand the list of parameters available.

>> ssms /?





























Below command is used to connect to SQL Server Management Studio using Windows Authentication. –E parameter is used to connect to SQL Server through Windows Authentication.

>> ssms –E
                              
Below command is used to connect to SQL Server Management Studio using SQL Server Authentication. It is connecting to [BYGQVS1-TEST] SQL Server Instance.-U indicates Username. –P indicates Password.

>> ssms –S BYGQVS1-TEST –U sa –P welcome@123