Problems inserting rows via Linked Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Problems inserting rows via Linked Server

Author

Topic

mhenriks
Starting Member

9 Posts

Posted - 2001-08-07 : 12:22:14

I need to update a local SQL Server table nightly from an Access database via linked server. Below are my futile attemptps.

Any suggestions?? Thanks in advance.

-- #1
INSERT INTO local_server_table

SELECT *
FROM linkserver...table_a
WHERE local_server_table.id <> linkserver...table_a.id

--ERROR
--Server: Msg 117, Level 15, State 2, Line 7
--The number name 'REMOTE_IADB...tblTransactions' contains more than the maximum number of prefixes. The maximum is 3.

--#2
INSERT INTO local_server_table

SELECT *
FROM linkserver...table_a
WHERE local_server_table.id <> linkserver...table_a.id
NOT IN (select id from linkserver...table_a)

--ERROR
--Server: Msg 107, Level 16, State 3, Line 1
--The column prefix 'tblTransactions' does not match with a table name or alias name used in the query.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources