Posted by Greg D. Moore \(Strider\) on 12/09/05 06:24

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns97265EFEEA685Yazorman@127.0.0.1...
> (pankaj_wolfhunter@yahoo.co.in) writes:
> > Thanx for the reply. One thing, i went through the docs of bcp utility
> > i didnt find any option for rebuilding the index.
> > Can you tell me the exact way of using it in bcp utility?
>
> BCP does not have any feature to rebuild indexes. You create the indexes
> with the regular T-SQL commands.
>

I have to do something like this quarterly.

The part I haven't bothered to automate yet is the script used to create the
indexes.

(That and dropping them... someday I'll script these parts.)

However, the rest is.

Basically I have a CMD file that I run at the OS level that truncate tables
in question.

Then it BCP's the data in and the calls OSQL to run scripts on the tables in
question to rebuild the indexes.

Basically it takes me about 1/2 hour of prep work (script out indexes incase
they've changed since last quarter), drop them, and then run the batch file
and walk away.


>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]