• Not sure I like the trigger idea either. Though you have to weigh the overhead of cursoring through the rows in the logical tables vs just firing the trigger once per row - how much different could it be? I can see where it would save writing a lot of repetitive code. I'd support it if it was an option and not a change in behavior (which would break too much code anyway), kind of a "with perrow" attribute.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/