Error Handling

• CDBA

  Hall of Fame

  Points: 3266

  More actions

  May 11, 2009 at 4:08 pm

  #204594

  How could I instruct a sp to coninue execution even if it faces an error.. I am looking for the same thing we used to pass in VB as "on error resume next"

  Please advice

  
  CDBA

• Lamprey13

  SSCertifiable

  Points: 6210

  More actions

  May 11, 2009 at 5:33 pm

  #992570

  Your procedure should/will continue (unless you have changed the default settings)

  SELECT 1/0

  SELECT 1

• CDBA

  Hall of Fame

  Points: 3266

  More actions

  May 11, 2009 at 5:40 pm

  #992572

  Here is what I am writing...

  cusror A

  from a list of 100 servers

  (

  sqlcmd server 1 (execute a command)

  )

  So now, if second server in the list in unreachable, still the execution will continue for third servers and so on...?

  Can you please confirm my understanding?

  
  CDBA