How to run sql script  from command prompt

Solution

Copy this  command in command prompt

 sqlcmd -S ASIFJAN\SQL2K12 -i E:\sp2.sql

if Sql script size is big file then we sh'd run script from command prompt  otherwise it will give some error.

run sql script from comand prompt