I have a few *.sql scripts. Typically a few Create DB Scripts followed by Modify DB Scripts and Then CreateSprocs Scripts. All these scripts need to be run on a daily basis.
Thus I want to Automate the process using a Batch Scripts os that Windows Scheduler can be used to automate at specific Time.
I was trying with SQLCMD, but was not sure of syntax. Can I use SQLCMD or should I use something else?