Help Creating trigger

I have written a SQL script containing many create/insert statements.i have to write a trigger which will be raised for failure of any statement in that script.can a trigger be written which will be raised for each statement and then the trigger code will check for the status(success or fail) of that statement?or can anybody suggest any proper solution for this?

thanks in advance... Received on Thu Oct 12 2006 - 02:29:26 CDT