Owing to my personal experience so far, I can undeniably say that Microsoft Windows products are outstanding. One of the reasons that make them exceptional is their little nifty tricks. For instance, every time I double click myfilename.sql it opens Microsoft SQL Server Management Studio (SSMS). The reason how Windows discerns that it has to open SSMS is because the extension of file I had clicked is .sql. I explored and found that SQL Server has few more filetypes associated with it, which are as follows.
SQL Server - .sql
SQL Server Compact 3.5 SP1 - .sqlce
SQL Server Analysis Service – .mdx, .xmla
Moving on, I would like to talk about another command that can open SQL Server Management Studio. Just type sqlwb in command prompt to open SSMS and bring credential prompt on screen.
I hope you find this article useful. Let me have your feedback so that we can take this topic further.
Reference : Pinal Dave (http://blog.sqlauthority.com)