Changing the name in one table means that the matching row can't have some completely different attribute changed in another table?
Keep in mind this will cause concurrency problems, may even cause deadlocks.
Select from the other tables with filters for the record_id and add the UPDLOCK, HOLDLOCK hints.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability