I want to copy data that is generated by view defination on sql server 2000.
When I execute the script to create table on another server I have specify
correct path (Server name, database name etc) Example to execute
CREATE VIEW viewname AS
What would be correct syntex (With server name, database name etc)
CREATE table tablename AS
from server.database.d, server.database.e
Can I do this directly by executing a query or have to use SSIS,
import/export or replication.