Run batch of sql files

Asked 11 years, 6 months ago. Active 7 years, 6 months ago. Viewed 26k times. Improve this question. Vishal Vishal Add a comment. Active Oldest Votes. I answered this in this other question : You should invoke the sqlcmd command-line tool from your batch file. Improve this answer. Community Bot 1 1 1 silver badge. Tahbaza Tahbaza 9, 2 2 gold badges 24 24 silver badges 39 39 bronze badges. Shessuky Shessuky 1, 17 17 silver badges 22 22 bronze badges.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Yes, I'm using the full path. It is the correct path on the server running it.

Add a comment. Active Oldest Votes. If memory serves me correctly: cmd. Improve this answer. If working directory is needed for script, you may need something like: cmd.

Good Luck. Check that you have permissions to run the batch file on that drive and folder location. Phill H Phill H 21 1 1 bronze badge. Laurenz Albe Ronald Tims Ronald Tims 11 1 1 bronze badge. Hi, Welcome to the site. While your answer may be useful it's usually better to include some more details as to why this would work while the command in the question doesn't. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

How can I make sure that only the output is written to output file. We have scheduled the job for. He holds a Masters of Science degree and numerous database certifications.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. Nupur Dave is a social media enthusiast and an independent consultant.

She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline. Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check , we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours. Once you learn my business secrets, you will fix the majority of problems in the future.

Leave new Jit. Anurag KUmar. Anurag Kumar.