I've inherited a SQL2000 database with tables on a secondary filegroup.
I'd like to keep indices on the secondary filegroup and migrate only the
data (and maybe the clustered index on each of the tables) back to the
primary filegroup. I'd like to continue to keep the nonclustered
indexes on the secondary filegroup.
Is there anyway to do this without literally dropping and recreating
all the indices ?
Your feedback and assistance is appreciated