oops the delimiters i used removed the code in between them on the last message
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 [olddatabase]..[oldtable])
Thanx,
Bill Elvin