select liRolePersonRoleId, liRolePersonPersonId, liRolePersonIncludedRoleId into #temp from tRolePerson

truncate table tRolePerson

DBCC CHECKIDENT ('tRolePerson', RESEED);

insert into tRolePerson
select liRolePersonRoleId, liRolePersonPersonId, liRolePersonIncludedRoleId
from #temp

drop table #temp
