>>Yes, set the recovery model to BULK before reindexing and back to FULL after.
>
>can this be done using a SQL command? If so how?
Yes, it should be with ALTER DATABASE command, but let me find out details.
::=
{
RECOVERY { FULL | BULK_LOGGED | SIMPLE }
| TORN_PAGE_DETECTION { ON | OFF }
| PAGE_VERIFY { CHECKSUM | TORN_PAGE_DETECTION | NONE }
}
See details on ALTER DATABASE in BOL.
If it's not broken, fix it until it is.
My Blog