How to copy data of one table from one server to another server using sql script..

Nov 8 2012 5:16 AM

How to copy data of one table from one server to another server using sql script..
As i want to make a sproc for daily run,bcz i dont want to go through the right click import/export functinality.

-sql server 2008

Plz help me.

Thanks. .

Answers (2)

Job in SQL Server

What is the difference between a "Where" clause and a "Having" clause