Resuming after error in TSQL script 
Author Message
 Resuming after error in TSQL script

Dear professionals,
I have a trouble with error handling.
In a stored procedure I'm using a BULK INSERT statement,
when BULK INSERT produce error for example:
  Msg 2627, Level 14, State 1
  Violation of PRIMARY KEY constraint 'PK_TTest'. Cannot insert
  duplicate key in object 'TTest'.
The statement and procedure execution has been terminated.
Are there some technique to handle error generated from BULK INSERT
statement and take appropriate actions, and how I can resume execution

Generally the problem is that on error all rest statements
after error are not executed, how I can resume to
continue execution after error?

Thank you in advance.

Sent via Deja.com http://www.***.com/
Before you buy.



Sat, 10 Aug 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. On Error Resume Next in TSQL

2. How can I script db from tsql script?

3. SP3 script error (Error running script 80sp3-tools.sql)

4. Oracle Resources (JOBS, RESUMES, LINKS, TUNING SCRIPT)!

5. Oracle Resources (JOBS, RESUMES, LINKS, TUNING SCRIPT)!

6. Oracle Resources (JOBS, RESUMES, LINKS, TUNING SCRIPT)!

7. Oracle Resources (JOBS, RESUMES, LINKS, TUNING SCRIPT)!

8. Oracle Resources (JOBS, RESUMES, LINKS, TUNING SCRIPT)!

9. Oracle Resources (JOBS, RESUMES, LINKS, TUNING SCRIPT)!

10. Oracle Resources (JOBS, RESUMES, LINKS, TUNING SCRIPT)!

11. Oracle Resources (JOBS, RESUMES, LINKS, TUNING SCRIPT)!


 
Powered by phpBB® Forum Software