>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham