>>>BTW, the correct syntax for above INSERT will be:
>>>

>>>insert into Ten_name (ten_pk, user_id, user_pwrd)
>>>select ten_pk, user_id, user_pwrd from Tenant x

>>
>>Will that work if the primary key is an auto-increment integer?
>
>What is the goal? Insert exactly same PK or let the PK autogenerate?
>
>In the latter case you need to remove PK column from the INSERT command fields.
>
>In the former case see SET INDENTITY INSERT command.
OK
Thanks, Naomi