SQL Server Identity Inserts (when doing batch import)

When importing mutliple tables from one DB to another and you have tables with 'identity' defination, when you try to import, you would face error, or if no error its event worst, the impor will screw up your identity or reset it, so below article tell you how to solve it, simple remember to check 'enable identity insert' in the wizard

http://blog.sqlauthority.com/2010/04/04/sql-server-enable-identity-insert-import-expert-wizard