Posted by m.bohse on 12/07/05 10:41

SQL Server has also a rebuildindex option, but in your case probably
somenone has decided to drop the index in order to speed up the
inserts. Ans once dropped you can't rebuild the index you have to
re-create.
In SQL2005 you have the option to disable non-clustered indexes during
bcp actions, but in 2000 you can't.

Markus

• Next in forum: Re: Reporting Services
• Prev in forum: Re: Should I worry
• Thread view: Re: Regarding Index Rebuilding

[Reply to this message]