We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the data got there.
If you have a way to do this please show an example. Thanks in advance.
Software/Hardware used: SQL Express, SQL Server 2005, Visual Studio & Desktop PC's