I thought if a table was less than 8 pages, it won't ever use an index...

I'm curious what you found as well.

Thanks,

Mike

Use EM to export data to the new server.  Choose the option to export database objects & select the tables you want to export.

Works for me in a similar scenario.

Mike

We're testing Dell's 2850 w/dual core chips.  They do run x64 versions of W2K3 & SQL 2005.

fyi

I'd be interested as well!

Thanks,

Mike