Running Windows Powershell Scripts simply opens it in the editor

Problem

I have a Windows powershell script that works fine in the interactive editor. The script is a simple one line sql cmd: When I enter that at the powershell command prompt it works fine. I save it in a ps1 file and try to run it from the cmd prompt by typing .\filename.ps1, it opens it in Notepad, an…