Could be many reasons. Can you "push" data to the remote server?<BR><BR>What formats are the local and remote servers? Both SQL Server?<BR><BR>Does it "come back" after a while and complete the operation, or does it hang completely? How are you doing an "import"? DTS? Replication?<BR><BR>Could you just use a remote linked server...?<BR><BR>Craig.
Yup! I can export data...<BR><BR>Yup! both are SQL Server<BR><BR>It hangs completely...I do import through the SQL Server Import/Export Console I think DTS coz I haven't done replication any database...<BR><BR>How could I use a remote linked server?