The script I used is for rebuilding all the tables whose fragmentation is above 30% and for reorganizing the indexes whose fragm is >5% and <30%. Here is the script...

--Variable...

make sure that you have varchar datatype both in source and destination. you will get that error when the datatypes are mismatched between nvarchar and varchar I guess..

It is replicated and we can't change the recovery model....But I m all set now with the dynamic views above....Thank you

Thank you very much for your reply...It was very helpful....

Thanks a lot for the reply.....so, I used sys.dm_db_index_physical_stats for a particular database and I got result ...for example, in the following row it has avg_fragmentation_percent as 96.56593...... so we...

Thanks a lot....that was useful...

yeah....It should work...Thank u very much...

Hi...I am having problems with the variable expression...I did 'nt understand what expression to put in the variable....the file name is like pakcage20080105.txt......could you please explain me what value i...

ok kool...now I got it...Thanks a lot...

Thanks for the reply....but where should we use this command? in the ssis package?? or cmd?? I m very novice in this...please don't mind...I just need to delete 15 days...

Hey RML51..........could you please explain in detail...where I should use the command given by you...I have for each loop container and file system task...I created a user variable...I don't know...

yeah....I tried using file system task and for each loop container....but it deletes all the files in it....may be I will try ur way....Thanks for the correction....

Thanks a lot....Let me try this....

I think we r not supposed to download these in production servers...But Thanks for the information...

u got this task done?? even I m waiting for the same task... please help me out if someone knows this....