Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

continue after error Expand / Collapse
Posted Monday, December 14, 2009 11:37 AM

Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 5, 2012 7:23 AM
Points: 304, Visits: 457
Is there a command that will ensue the sql script does not exit execution if there is a critical error. For example say i'm selecting from a db that doesnt exist and i dont want the script to stop execution after it errors.
Post #834033
Posted Monday, December 14, 2009 11:41 AM



Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 14,541, Visits: 38,382
the GO command after every related group of commands would do what you want, i think.
you'd want to make sure there was no explicit transaction open i think, as well.


help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #834035
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse