Hi Folks,

I have created a DB table and inserted data in that.Now would like to import that whole data into another Server.

I have created table with script but how to insert total data into that server?

Thanks in advance

Use SSIS or DTS. 

Either you script out the data along with the schema [better to use some tool] or add it as a linked server and query it out or export the table data [dts wizard]

Depends on data size, number of records.

If not more than few hundreds records, and only one time job then go for script.

If ongoing activity and lot of data, then go for SSIS and jobs.