<div>
Great that worked. &nbsp;Could you tell me why? Or when to use create table vs. select * into?
</div>


Great that worked.  Could you tell me why? Or when to use create table vs. select * into?

<div>
Quite simply; If you have a table that you wish to insert into that already exists - use Insert Into otherwise use Select Into.<br />
<br />
Be aware that depending on the number of rows in your source database; this could take some time. Also be aware of referential integrity on your new database.<br />
<br />
HTH
</div>


Quite simply; If you have a table that you wish to insert into that already exists - use Insert Into otherwise use Select Into.

Be aware that depending on the number of rows in your source database; this could take some time. Also be aware of referential integrity on your new database.

HTH

<div>
<div class="content wysiwyg-content">
Hello,<br />
Using MS SQL Server 2000 I'm trying to create a new table that will contain all table and fields from another table on a Linked Server. &nbsp;<br />
<br />
Using:<br />
CREATE TABLE INT_USER AS(select * from interaction.interaction.db<wbr />o.INT_USER<wbr />);<br />
<br />
I get the following error message:<br />
<br />
Msg 156, Level 15, State 1, Line 1<br />
Incorrect syntax near the keyword 'AS'.<br />
<br />
I can just run the select statement and return records.<br />
<br />
Thanks for your help.
</div>
</div>


Hello,
Using MS SQL Server 2000 I'm trying to create a new table that will contain all table and fields from another table on a Linked Server.  

Using:
CREATE TABLE INT_USER AS(select * from interaction.interaction.dbo.INT_USER);

I get the following error message:

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'AS'.

I can just run the select statement and return records.

Thanks for your help.

Create table from table on a Linked Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.