>>>First, thank you. But these SQL Server databases are on different servers (different companies). So I don't think the above syntax will work.
>>
>>How many records? If low, you can script them and run the script on the database #2.
>
>The number of records is not that great (probably less than 1000). I didn't realize that you can script the table with the values (I thought script is for creating the structure of a table). Do you remember/have an example of a syntax of such script?
>Thank you.
SSMS
Right Click on Database and select Tasks->Create Scripts
Follow the wizard.
Click on Advanced button when Set Scripting options screen appear.
Scroll down to Types of data to script and select Schema and Data.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.