and we never shrink the database in auto....we always do it manually...

The record_count is around 3 million. The fragmentation is 87% before the rebuild. even after the rebuild it shows same 85%. Now, I dropped the index and recreated it. now...

Thanks for all the inputs....

@Gila : The index pages are around 70MB in size. So, Please let me know if I can Reduce the defragmentation in the indexes!!!

Thanks for the quick reply....So, can't we defragment the non clustered indexes??

Any solution to this yet!!! I have got the same problem....I am able to send small files...but Its timing out for the large files say like 3MB....but SMTP server allows...

may be u r right neol...It should be access problem....I will change the owner name and the table name to dbo.tablename ....I will check tonight if it is gonna be...

Thanks for the reply....

That object exists in the database....

Thank you for the reply....I figured it out that It is maximum History log size limit...I posted if we have any other settings....

Sounds good....Let me try this....

Thanks a lot..

Thanks for the quick response...

We already have the Linked Server...

So, do we have to Disable the job in server B and then create a Job step with...

Awesome....It worked out....

Thanks a lot

yes....what a silly thing...

Alrite ...Thanks a lot for the quick reply...

Thank you both for your quick replies....Actually It has got some trillions of data, so I got to change the query design itself....@Michael, The suggestion u gave is very informative...

Thanks for the reply...But, I was trying to copy entire query plan to a file....But I can copy only 1 query plan at a time...Is there anyway that we can...

Thank you very much for the information.....I created DDL trigger on the database....