Copying data from one server table to another server's table
<p>I am having two servers. Both server have one common table. </p>

<p>Table-Name: <code>ref_state</code></p>

<pre><code>Column_name          data_Type
------------------------------------
state_id           smallint
country_id            int
state_short_name    nvarchar
state               nvarchar
is_active              bit
last_update      smalldatetime
is_town               bit
</code></pre>

<p>I want to take one server table data into another server table. </p>

<pre><code>select * from ref_states where country_id=2
</code></pre>