>>>I need to append a table from a SQL Server database into another table of the same name and same structure in another SQL Server database.
>>>
>>>In Visual FoxPro, this can be done with the APPEND FROM command. Is this a mystery or I couldn't find a command like for SQL Server? Do I have to do a Visual FoxPro program to loop for each record and insert them manually into the other table?
>>
>>You can use INSERT-SQL (it's richer in SQL Server)
>
>Am I correct that using a statement similar to this should be what I should focus to?
>
>INSERT INTO NEWDATABASE.MESSAGE SELECT * FROM OLDDATABASE.MESSAGE

Yes, it works.