How to handle DDL errors in T-SQL??

Question

Post reply

How to handle DDL errors in T-SQL??

guptaopus

SSCommitted

Points: 1534
More actions
May 8, 2008 at 12:20 am

#190174

Hi,
I have a insert statement in which destination table does not exist, in this case transaction will be uncommitted as it cannot handled neighter by @@Error nor by try catch. is there any solution where i can handle DDL errors?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

Hi

Check whether the table exists and then insert.

"Keep Trying"

guptaopus SSCommitted Points: 1534 More actions · Answer 2

Even if table exist now, I want to handle this situation in future any table is dropped and I dont want my SP to suffer. so any workaround on it?

ChiragNS One Orange Chip Points: 26137 More actions · Answer 3

Yup... check for the tables existence before doing the inserts using IF EXISTS.

BTW what do you mean by table is dropped in future? Its better to check before dropping a table.

"Keep Trying"

Mahesh Bote SSCrazy Eights Points: 9107 More actions · Answer 4

[font="Verdana"]

guptaopus (5/8/2008)
Even if table exist now, I want to handle this situation in future any table is dropped and I dont want my SP to suffer. so any workaround on it?

Anyway Chirag is absolutely right. You need to check whether the table exists or not. If so, then and then only go for Insert otherwise in else part raise error that table is not present in DB. Its so Simple. Why you need to worry about dropping table then? You SProc is not going to suffer anyway.

Mahesh[/font]

MH-09-AM-8694