Please start any new threads on our new site at 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 

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.


- Advertisement -