SQL SERVER – How to Invoke SSMS Help From Command Prompt?

This particular question I just received in my recent SQL Server Performance Tuning Practical Workshop. It was a very interesting question and hence I am going to blog about it. The question which I received was – How to Invoke SSMS Help From Command Prompt?

There is yet another method to invoke SSMS is using the command prompt. In fact, the shortcut is SSMS.

C:\> ssms

This will bring up the SSMS just like the shortcut we invoked before. The more interesting way to look at this shortcut is to check the various options available with SSMS command line parameters. To check them, use the following command:

C:\> ssms /?

SQL SERVER - How to Invoke SSMS Help From Command Prompt? 2-zerotohero

This brings us various options as shown. The most interesting option here is the capability to use the –S option like SQL Server Name and the steps it normally takes to make an SSMS studio completely operational for work would include close to 3-4 clicks. If we use the –E option, then we can load the SQL Server Management Studio directly with a query window.

Let me know if you know this trick? If you know any such tricks, please post it here in the comments section and I will publish the blog post with due credit. I am writing a whitepaper on this subject and I will soon share the link to the blog post.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Server, SQL Server Management Studio, SSMS
Previous Post
SQL SERVER – Windows Authentication or System Admin Account (SA)
Next Post
SQL SERVER – SQL Server Configuration Manager Missing from Start Menu

Related Posts

Leave a Reply