I am studying the 70-431 & have a question:
if there is an existing table in the main filegroup and want to move it to a second filegroup:
is the only option is to re-script the table and append the existing data?
I looked at the alter table BOL and did nothing jumped out at me.
Thanks in advance!