Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

continue after error Expand / Collapse
Author
Message
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:24 PM
Points: 12,881, Visits: 31,816
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.



Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #834035
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse