0

I have a file named "CreateDatabase1.script". I want to create a database from this file but this file is not executable in SQL Server management studio. How can I run this file and create this database??

Subodh Wasankar
  • 309
  • 2
  • 6
Dhara Vaghasiya
  • 268
  • 3
  • 14
  • 1
    Without any information about the contents of the file nor any context, it is unlikely you will get help. Start by defining exactly what "not executable" means. There are many tools that will read files contains SQL statements and execute them. Do you have any? Do you have access to a SQL Server instance? – SMor Jun 01 '21 at 20:07
  • You need to associate the '.SCRIPT' file extension with SSMS Editor. See my answer. – Subodh Wasankar Jun 01 '21 at 20:16

1 Answers1

1

You need to associate a file extension with SSMS Editor.

enter image description here

Subodh Wasankar
  • 309
  • 2
  • 6