Hey Sergey
I have seen this "dbo" notation before but it has usually caused me grief. There doesn't seem to be much in the thelp about it. What is it exactly?
Regards
Geoff
>
INSERT INTO db2.dbo.table2 SELECT * FROM db1.dbo.table1
>
>>I wish to copy records from a table in one database (db1.table1) to a similar table in another database (db2.table2), but I am not sure about the syntax.
>>
>>I guess it would go something like...
>>INSERT INTO db2.table2 (SELECT * FROM db1.table1), but this does't work.
>>
>>Any help would be appreciated.
>>
>>Alan
May all your weeds be wildflowers