>>INSERT INTO NEWDATABASE.MESSAGE SELECT * FROM OLDDATABASE.MESSAGE
>
>Yes, it works.
Ok, thanks, I obtain this result but I'll manage to make it work.
Msg 208, Level 16, State 1
Invalid object name 'dbc.message'.
Msg 208, Level 16, State 1
Invalid object name 'acronym.message'.