SSMS 2017 - How to restore .sql file association?

windows-10 sql sql-server file-association sql-management-studio

Solution 1:

In Management Studio:

  • Tools
  • Options
  • Text Editor
  • File extension
  • add .sql
  • OK

Solution 2:

All of these answers are wrong. You have to repair SSMS. If you manually reassign .sql files, they will open with SSMS, but not in the proper way, which leads to multiple instances.

In my case repairing was only possibly by re-downloading the installer, as add/remove programs failed when I tried to repair it there.

Related

Damaged USB after using RUFUS
Daily life as a math professor [closed]
Intuition behind Descartes' Rule of Signs
Log Trig $\int_0^{\pi/2}\log^4 \tan \frac{x}{2}dx=\frac{5\pi^5}{32}$
Why are normal subgroups called "normal"?
The Uniqueness Part of the Smooth-Manifold-Chart-Lemma in John M. Lee's Introduction to Smooth Manifolds.
Under what conditions will the rectangle of the Japanese theorem be a square?
Is $50$th percentile equal to median?
show that $a_{n+874}=a_{n}$,if such $a_{n+2}=\left\lceil \frac{4}{3}a_{n+1}-a_{n}+0.5\right\rceil$
$n=pq$ with $p<q$ odd primes is there a fast way to determine if $p-1|q-1$ without knowing $p$ and $q$
Factoring $1+x+\dots +x^n$ into a product of polynomials with positive coefficients
Do there exist four polynomials with real coefficients so that ...