Question:

Hello

I need to copy a table form one database to another. The databases are on different servers, different IP’s. I have SA access to both via Management studio. I also have Remote Desktop access to both servers.   How can I do this?

Solution:

Refer material – http://blogs.techrepublic.com.com/datacenter/?p=319.