This is SQL Server problem and I apologize if gentleman is giving recommendations on Sybase. I would like to know any solution you guys can suggest. Apprecite it.

Thanks

Faisal

I did not change anything to that parameter but here it is what I got from EXEC sp_configure, that shoudl be the default settings as 0 says:

name                              minimum     maximum      config_value ...

Hi, Thanks for your input. I am sorry the reindexing job is running on every Sunday, it was mistake on my part to tell on daily basis. I tried to...