Thanks for the information. Can you please send me if you have one script.

Thanks in advance.

Ichbinraj

Hi ,

I am planning to do on-line Reindex for 100 tables one by one.

Is it possible to put them in script like when 1 st table done then...

Thanks for the scripts.

correct me if I am saying wrong ....

I know its really good to have it but I could see we are checking fragmentation level before doing...

Its SAP system and every day they have huge transports .. very hard to find maintenance window ..

Quick Question about my process : Am i doing right thing for indexing...

Thanks guys ,

Is It best to put FILLFACTOR = 80 ?

ichbinraj

oh my good ness...

Thanks guys .. I missed the ONLINE = ON); statement I really Appreciate your help and suggestion

Thanks

Ichbinraj

Thanks for your information.

I Have 1 TB database nearly 68,000 tables its heavily used database . I am doing on-line indexing on only large tables and large indexed tables...

I have tested this statements on test-server already.. found no errors

Yesterday I tried again to run this statement .. found users are disconnecting from the session ..

any information why...

Is it possible to restore from recent backup ?

look like its going to take nearly 22 Hrs to complete.

experts : can we do this thing ?

Thanks

Ichbinraj

Hi ,

Job is running under service account and I have explicitly added this account to admin group on that network path server.

one more thing .. i tried changing...

Hi thanks for your information

Here is the DTS Package error log.

Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description:Error Code: 0

Error Source= Microsoft VBScript runtime error

Error Description:...

Hi ,

Can you be more specific..

Job is enabled and tried using different users like service account and SA still not working

Thanks

ichbinraj

Do we have any kind of other method to resolve this problem ?

Thanks

ichbinraj

Hi rows information

A ( Records 38543)

B (Records 46873)

C (Records 110857)

D (Records 36227)

E (Records 43559)

Yes these tables are also used by SAP application

Thanks

Ichbinraj

Check the logs for more information.