How to open SQL Server Management studio from command prompt – TIP#21

It is just a simple tip nothing fancy.

On command prompt you just type SSMS and hit OK.

Your SQL server Management studio will be open.

You can get other option also by typing ssms/? .

You will get below options

Now if you want to login to particular SQL Server Instance you can choose option as mention in above screen.

For example to open SQL Express version on my machine, I wrote query as shown in below image


Leave a Reply

Your email address will not be published. Required fields are marked *