Are you on 2k5 or 2k8? I ask because poeple often post in the wrong forum.

Assuming 2K8...

Wouldn't it be possible to create a unique filtered index to avoid the pain of the triggers?