>none of those, it just says trigger fails.
>
>out of subject: i posted another thing ata the sql server forum, how can i see it?

none of those? Why it fails then:) Trace with profiler. BTW 'wrong code' is contraints etc inclusive.
Select forum from drop down on top and click go. Or directly clicking your name then messages might work.
Cetin