what if you just used the DTS copy sqlserver objects task and set the ScriptOptionEx integer value to 8388608
which translates to;
Do not script the collation clause if source is an instance of SQL Server version 7.0 or later. The default is to generate collation.not script the collation clause if source is an instance of SQL Server version 7.0 or later. The default is to generate collation.
?
Hi,
Let me add my voice to the chorus of compliments. GREAT WORK!
The only problem I encountered was with timestamp columns, for which I kept getting the following error:
Server: Msg 273, Level 16, State 1, Line 3Cannot insert a non-null value into a timestamp column. Use INSERT with a column list or with a default of NULL for the timestamp column.
So I had to modify all my statements to remove the insert NULL values into the timestamp columns. I would immagine the best thing though would be to not include those columns in the INSERT scripts at all. Do you agree?
Mauro Ciaccio
....thought it was too simple.....
By writing NULL to the timestamp columns, the checksum calculation done by your Script2 then fails.
