hI ALL,
I have two identical table name "A" and "B". table "A" has no data and Table B has data. I want to insert all data from B to A, But problem is that one column in the table is defined identity with increment 1 seed 1. so it gives me following error 8101
"An explicit value for the identity column in table '%.*ls' can only be specified when a column list is used and IDENTITY_INSERT is ON".

How can i insert all the values from table B to Table A,

Thanks,
....ashish