4

After installing SQL Server Management Studio 2017 and uninstalling SSMS 2016, Windows 10 shows the "How do you want to open this .sql file" screen every time I try to open a sql file.

How do you want to open this .sql file

When I look at file type association setup, it doesn't show .sql extension:

Choose default apps by file type doesn't showing .sql extension

Is there any fix to this issue without manual registry manipulation and 3rd party utilities?

natenho
  • 176

4 Answers4

3

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.

Dan
  • 182
1

In Management Studio:

  • Tools
  • Options
  • Text Editor
  • File extension
  • add .sql
  • OK
studiohack
  • 13,477
Marzieh
  • 11
-1

To associate a new file extension with SQL Server Management Studio

  1. On the Start menu, point to All Programs, point to Accessories, and then click Windows Explorer.

  2. In Windows Explorer, on the Tools menu, click Folder Options.

  3. In the Folder Options dialog box, on the File Types tab, click New.

  4. In the Create New Extension dialog box, in the File Extension box, type the new file extension that you want to associate, and then click OK. Do not start the extension with a period.

  5. In the Registered file types box, click on your new extension, and then click Change.

  6. In the Open With dialog box, click SSMS - SQL Server Management Studio, and then click OK.

  7. Click Close to close the Folder Options dialog box, and then close Windows Explorer.

Source: To associate a new file extension with SQL Server Management Studio

To associate a new file extension with a code editor in SQL Server Management Studio

  1. In SQL Server Management Studio, from the Tools menu, click Options.

  2. In the Options dialog box, click Text Editor, and then click File Extension.

  3. In the Extension box, type your new file extension.

  4. In the Editor box, click the code editor that you wish to use to open this file type, click Add, and then click OK.

Source: To associate a new file extension with a code editor in SQL Server Management Studio

eekinci
  • 101
  • 3
-2

In SSMS I clicked on File, Open, File and all of the .sql files in the default location appeared. To test I simply clicked on one and it opened.

Steven Deetz
  • 1