>>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