>using SQL 2008 R2, how do you copy a table into the same DB with indexes?
Script it with SSMS and run generated script.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
