Remove duplicate records from a table

If in an old table in sql server 2005,by mistake you have duplicate records you can create a new table with distinct records using:

select distinct *  into New Table

from Old Table