Thanks, Ralph, I was kind of afraid of that. I don't think either
alternative is very attractive; so I have to wonder why a single row update
would trigger a large table to be truncated!
_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfeeŽ
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
MS Sql Server LazyDBA home page