<div>
Couple of minor points..<br />
(1) &nbsp;Your database name is grel01.falcon, correct?<br />
(2) &nbsp;It's widely considered proper design to INSERT specifying all columns, and not with the all-columns asterisk (*). &nbsp;
</div>


Couple of minor points..
(1)  Your database name is grel01.falcon, correct?
(2)  It's widely considered proper design to INSERT specifying all columns, and not with the all-columns asterisk (*).  

<div>
jimhorn, I completely agree.
</div>


<div>
<div class="content wysiwyg-content">
I am using the following command to insert records in a table:<br />
insert into grel01.falcon.dbo.job_ext(<wbr />select * from tsdaft.falcon.dbo.job_ext where id &gt;&nbsp;140213)<br />
<br />
I keep getting the following error:<br />
Msg 156, Level 15, State 1, Line 1<br />
Incorrect syntax near the keyword 'select'.<br />
Msg 170, Level 15, State 1, Line 1<br />
Line 1: Incorrect syntax near ')'.<br />
<br />
The query seems perfectly fine
</div>
</div>


I am using the following command to insert records in a table:
insert into grel01.falcon.dbo.job_ext(select * from tsdaft.falcon.dbo.job_ext where id > 140213)

I keep getting the following error:
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'select'.
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ')'.

The query seems perfectly fine

Problems inserting records in a SQL Table

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.