Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Site Related Forums  Article Discussion  copying a table with identity column

Author  Topic  dith Starting Member 24 Posts Posted - 2001-08-20 : 19:35:14 How would copying a table (with an identity column) from one database to another affected by the table's identity column? Would the records in the new table have the same numbers (row_id) as the old table? what is the safest way to copy a table without shuffling all the values in the identity column? (dts export? select into?) thanks in advance.