river1 (3/18/2010)
When i use the export data tool (to send the table to other database), i can send the table, but i cannot create in the destination database the primary key and the identity field.
Thank you Pedro. Just to be absolutely clear, you want to transfer the whole table, including the column with the IDENTITY property, and re-create the primary key. The IDENTITY column should retain the same values too...right?
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi