Tag Info

New answers tagged


You're lacking the -E flag for identity columns, which allows you to preserve the values instead of re-seeding them on the import. bcp DocControl.dbo.Documents in Documents.dat -n -E -S SERVER\SQLEXPRESS -T From MSDN, [-E] Specifies that identity value or values in the imported data file are to be used for the identity column. If -E is not given, ...

Top 50 recent answers are included