SQL SERVER – Server Type and File Extention

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)

About these ads

4 thoughts on “SQL SERVER – Server Type and File Extention

  1. I fail to see what is so impressiva about recognising file types by extension. It is one of the many CP/M features copied by microsoft when they originally produced MS/DOS. I think you would find file association with programs to be a common feature if you ventured outside your Windows only environment

  2. Great Post Pinal, thanks :)

    let me just add a little note: if you type profiler90 on command prompt (or on the StartMenu->Run dialog) u’ll get a brand new SQL Server Profiler window :)
    This is a tool that i really like about SQL Server. It helps a lot on debugging ASP.NET WebApps :)

  3. Pinal – Have you come across a scenario where every time you open a “.sql” file it opens a new instance of SQL Management Studio? I am using Windows 7 with SQL Denali (2011). Do you know how to make it open in the same instance?

    I think it has got to do with the file extension setting in registry.

    Thoughts?

    Cheers,

    Deepan S,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s