maida_rh (1/31/2013)
I tryed TRUNCATE on table but still the same error of PK violation during import/Export.
So it means your source table contains duplicate data ? do you have same PK on source table too as you have on dest table ?
maida_rh (1/31/2013)
What does AuTHORIZATION do ?If I assigned to sa ?
See the link i posted above
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)