Today I am going to share some small dos which will helpful to open SQL Server Management Studio.
I am sure you are curious about
how to open SQL Server Management studio with command prompt.
So Let us start Currently when you go through SQL Server Management studio you have to process 2 step means first click the SQL server Management studio by clicking icon then login to the server.
Now check this out write following command in dos command prompt and press enter
C:\> ssms –E
You will find your SQL Server Management studio open without any prompt of Login authentication because here E stands for windows Authentication mode.
Now go deeper write following command
C:\>ssms –E –NOSPLASH
Now you found that the splash screen also not coming ,So similarly you can find various options to open SQL SERVER Management Studio using command prompt.
You will get following screen and you can any option from below screen to proceed further.
I hope you enjoyed the trick.
Thanks & Bes Regards, Rajat Jaiswal