comparing tables on SQL Server 2005/2008

I've been using a god awful UNION ALL script and you can now compare using the EXCEPT statement:

select * from table1
except
select * from table2



short and sweet !