Stopping Powershell script to continue after an SQL error inside of the script fails?

Question

I have a PS script which connects to MS SQL and makes changes in the DB and if the SQL script fails, my ps script still continues with the next steps. So I wonder what is a good way to stop the script after it failed on SQL side? My Powershell didn't recognize the normal abortion from SQL, so is the another way?

Posting the code you're working with will help people help you. — alroc
– alroc, Commented Jan 9, 2014 at 13:45

Paul · Accepted Answer · 2014-01-09 11:22:45Z

1

If you find a way to check if your SQL script worked or not (if you don´t know how you should provide a little more info on what you are doing), you can use Break to stop your powershell script.

answered Jan 9, 2014 at 11:22

Paul

5,9412 gold badges27 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chad Miller · Accepted Answer · 2014-01-09 11:43:21Z

1

Take a look at $ErrorActionPreference. You can set this at a script level to Stop.

answered Jan 9, 2014 at 11:43

Chad Miller

42.4k4 gold badges33 silver badges34 bronze badges

Comments

mjolinor · Accepted Answer · 2014-01-09 11:51:19Z

1

This is basic error handling. See if this help:

http://www.microsoftvirtualacademy.com/Content/ViewContent.aspx?et=3447&m=3443&ct=18350#?fbid=8N34OvP1Y5K

answered Jan 9, 2014 at 11:51

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

Collectives™ on Stack Overflow

Stopping Powershell script to continue after an SQL error inside of the script fails?

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related