ALZDBA (12/11/2011)

As others...

Lowell (12/10/2011)

Richard my suggestion would still be the same; no trigger involved at all.

I'd use staging table that keeps track of primary keys, and a flag that tracks whether...

Oops duplicate post

I wonder what would cause you to plan like that? What is the real issue you're trying to solve?

Auditing? Mirroring? Do you understand the performance implications of such design?

I personally...

I like SPs since there is at least some likelihood that the various patches have been tested with each other for compatibility.