My method for duplicate removal  may not suit every one. it offers the advantage if you have duplicate data but the identity column makes the data unique you can modify the select * to only the duplicated fields.

begin tran

Select Distinct * into [newtable] from [badtable]

truncate table [badtable]

insert into badtable select * from newtable

drop table [newtable]

ColinR