I think that there is one more way to do this- Update the table , then check for the @@rowcount. If @@rowcount > 1 then perform the insert operation -

1....

select name from sysobjects where xtype = 'U' and name like '%XXXX%'

Well 2 options come to my mind:

Begin an explicit transaction while updating the table. In the same transaction, write an insert statement to the history table. In this case, the insert...