RE: how to make a delete statement fail

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:O
N:WL:en-US:SI_SB_online:082009>

Other related posts: