This will work for the case the entire row is duplicates (all columns).

select distinct * into WorkTableA from TableA

go

drop table TableA

go

sp_rename WorkTableA, TableA

go