>>If you are trying to keep the identity column in the new table in tact then you can't bulk copy but you can do an insert select. ex.
>>
>>INSERT INTO newdatabase..newtable(AllColumnsExceptIdentity FROM SELECT AllColumnsExceptIdentity FROM
..)
>
>I see. Being lazy I hoped to avoid writting all the fields. I can probably try to generate an Insert procedure then and modify it accordingly.
>
>Thanks a lot.
In the auto-generated Create table script why the case for field names is not preserved and all fields are in lower case? Does it matter?
If it's not broken, fix it until it is.
My Blog