MS Access has a button to generate sql code for finding duplicated rows. I don't know if SQL Server 2005/2008 Managment Studio has this.
If it has, please point where
If it has not, please tell me how can I have a T-SQL helper for creating code like this.