• This time I tried logically and thought that after Truncate command the distribution statistics must be deleted. But I got wrong. Anyways learnt something from this.

    But still I think you should have added the versions of SQL Servers as In SQL 7.0 it's not a True case.

    Regards,

    Sudhir