Please note below text marked in bold . As you can see script creation date and time are added in script file. Can we avoid this.

/****** Object: ...

I haven't used the posted scirpt, I tried it doing some other way.

But I am sure even if I use the posted script at the start of file date...

Hi,

I have generated scripts of all SQL objects(table,veiw,UDF, stored procedure) using SQLDMO.SQLServer2 system object.

Definition of Triggers are included in script file of table. How can this be avoided and...

Are you planning to use partition to archive the data. If so what will be the key for partition.