try deleting a parent key that has child keys still somewhere in a PK/FK relationship Jack 2009/8/27 Larry G. Elkins <elkinsl@xxxxxxxxx> > Delete trigger that raises error > > > > If execution plan uses index for criteria do an alter index xyz unusable, > assuming skip_unusable_indexes is false (don’t do this if this is a > multi-billion row table ;-)) > > > > > > Larry G. Elkins > > > > > Joe Smith wrote: > > How do I make a correct DELETE statement fail? I have a developer that > wants to test a code branch and he needs a delete statement to fail. > > > > It can’t be locked ( shared or exclusive ) from a separate session or be an > incorrect statement or return “0 rows deleted.” > > > > It has to be “delete from table where col = value”. How can I force that > to fail? > > > > > > thanks. > > > > > > > ------------------------------ > > Windows Live: Keep your friends up to date with what you do online. Find > out > more.<http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_online:082009> > -- Jack van Zanen ------------------------- This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation