Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

displaying error messages using the sqlcmd utility

Status
Not open for further replies.
dmando84

dmando84

Programmer
Dec 28, 2005
68
US
Hello all,

I created a batch file that runs sql scripts in a specific order. The only problem is that the scripts continue to run even after it encounters and error in SQL. Does anyone know how I can stop the script from running when it encounters any errors? Any help would be appreciated.

Thanks,

Dave
 
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
421
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
246
Mike Lewis
Mike Lewis
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
298
Andrzejek
Andrzejek
Virendra Yaduvanshi
  • Locked
  • Question
SSRS - Subscription page error
Replies
0
Views
120
Virendra Yaduvanshi
Virendra Yaduvanshi
TheBugSlayer
  • Locked
  • Question
How to make xp_cmdshell use SQL Server's bcp utility instead of Sysbase's 1
Replies
7
Views
490
Nick_Evans1
Nick_Evans1

Part and Inventory Search

Sponsor

Back
Top