<div>
forgot to add but here is my error with abover insert code:<br />
<br />
contains more than the maximum number of prefixes. The maximum is 2.<br />

</div>


forgot to add but here is my error with abover insert code:

contains more than the maximum number of prefixes. The maximum is 2.


<div>
Thanks Gentlemen...really helped out here. &nbsp;Glen
</div>


Thanks Gentlemen...really helped out here.  Glen

<div>
<div class="content wysiwyg-content">
I have a remote db within my local studio; configured the linked server...<br />
I can perfrom a select on the remote db by:<br />
select * from [192.xxx.xxx.xxx].testdb.d<wbr />bo.table<br />
<br />
What I would like to do is insert data from a local table into the remote table:<br />
<br />
select *<br />
into [192.xxx.xxx.xxx].testdb.d<wbr />bo.table<br />
from table
</div>
</div>


I have a remote db within my local studio; configured the linked server...
I can perfrom a select on the remote db by:
select * from [192.xxx.xxx.xxx].testdb.dbo.table

What I would like to do is insert data from a local table into the remote table:

select *
into [192.xxx.xxx.xxx].testdb.dbo.table
from table

How do I perform a 'Select Into&quot; on a remote server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

How do I perform a 'Select Into&quot; on a remote server

How do I perform a 'Select Into" on a remote server