Hi,

I would like to suggest the approach below:

1) For every tableX, add a row which defined the primary key columns.

e.g.

;with pk_cols as (

...

Not sure on your requirement.

I had prepared the sample given, and below is what I can think of to produce the output given.

;with dy_tb as (

select distinct tableName from @systemTable

),

pk_cols...

Hi All,

Thank you for all of your replies.

I am trying to execute the DTS in SQL 2000 contains Copy Server Objects which has destination server is SQL 2008 (formerly was...