>>>>Hi,
>>>>
>>>>I need to copy a table from one database to another, on the same SQL Server. I tried using Task -> Import wizard but does not seem to give me a choice of just selecting one table. Is there a way to select just one table when Importing? Or it there another way to copy the entire table from one db to another?
>>>>
>>>>TIA
>>>
>>>
>>>You can do that straight from SSMS. Right Click on the database you want to import a table into and click on Tasks and then Import Data. A wizard will walk you through it.
>>
>>I see. I get a lot of violations. So it looks like I have to disable the Identity columns on the table into which importing. Otherwise, the Import probably copies the values from the Identity columns.. Is this correct?
>
>No. If you go into the mapping options, you can tell it to allow identity insert. Only do that if you want to make sure your identity fields are in fact identical to the original table.

Actually I do want the identity columns to copy because I have 2 tables and one is related to another. But what I find is that the column timestamp_column gives me error. It must be a read-only column. But I can't see in the Column Mapping a choice to exclude this column.