To execute a .sql file, you need to open the Query Analyzer
You can get there by going to
Start → Programs → MS SQL Server → Query Analyzer
Connect to the database that you’re running the script on.
Then open the SQL file using File → Open
Once it is open, you can execute the file by pressing F5.