Northwind.bak.zip works but Northwind.sql.zip has problems in SQL Server 2012

Oct 25, 2013 at 10:13 AM
All suggested methods were tried.
  1. Northwind.bak.zip works and it takes only 3 steps.
  2. The SQLCMD does not seem to work, the switch -S is flagged as erroneous
  3. Running the script has problems but there is a work around.
    Problem 1: Encoding comes up with auto-detect as default, and the text has some formatting problem
    Problem 2; If you choose wesern European codepage 1252 has the same problem
    work around: Copy the text in the download file and paste it to Notepad and then open the file from Notepad in SSMS and run the script.