SGolds
SGolds

Reputation: 139

SQL Server Management Studio not opening files

I just installed Microsoft SQL Server Express and Management Studio, the Management Studio opens but will not open files. I am getting the following message when I try to open a SQL file:

error message

Any help would be so much appreciated. Thank you

Upvotes: 0

Views: 1748

Answers (2)

Emily Fei
Emily Fei

Reputation: 64

This is the known issue in SSMS 18.0 preview 6 and before.

Double-clicking on a .sql file launches SSMS, but does not open the actual script.

As workarounds, please drag and drop the .sql file onto the SSMS editor.

If it is possible, you can use the SSMS 17.9.1 instead. Here is the download link.

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Upvotes: 1

Mathew Dodson
Mathew Dodson

Reputation: 125

This may be due to the fact that you're asking to grab something from an unaccessable directory. I'm not too sure, try reinstalling ssms if possible and reinstall sql express and see what it does

Upvotes: 0

Related Questions