Home Forums Data Warehousing Data Transformation Services (DTS) Copy data RE: Copy data
AJ Ahrens
SSC-Insane
Points: 20676
More actions
June 3, 2003 at 7:52 pm
#459630
Is the ID field an IDENTITY field?? If it is you can SET IDENTITY_INSERT ON
Then you can insert your identity from table a into table b.
SQL DBA
Revenue Assurance Management - AT&T
Good Hunting!
AJ Ahrenswebmaster@kritter.net