Vedran Kesegic (1/11/2013)
I hope it is not your regular procedure, because updating primary key which is by default also a clustered index key, is a very bad idea because of fragmentation and slow operation.
i would say , EITHER you are miskenly updating the root column (PK/FK column) OR you have bad business/database design here where you have to make changes in contactid (PK/FK )
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)