Home Forums SQL Server 2008 T-SQL (SS2K8) Automating .sql Scripts RE: Automating .sql Scripts
grahamc
SSCertifiable
Points: 6762
More actions
September 30, 2010 at 6:18 am
#1229547
Use the Windows Scheduler to execute a SQLCMD command and point the SQLCMD to .sql file. There are other connection details that SQLCMD will require, but this is how I used to do this at a previous place.