SQL Server Linked Server

Question

All,

I am trying out a new linked server - I can run this command fine:

SELECT * FROM NextGen4.NGEPMWareHouse.dbo.Network_People

If I try to get fancy (update a table on my local server from the linked server)

UPDATE dbo.Network_People
SET dbo.Network_People.NGTimeStamp = NextGen4.NGEPMWareHouse.dbo.Network_People.[TimeStamp]
WHERE dbo.Network_People.HIN = NextGen4.NGEPMWareHouse.dbo.Network_People.HIN

I get

The number name 'NextGen4.NGEPMWareHouse.dbo.Network_People' contains more than the maximum number of prefixes. The maximum is 3.

Tomalak · Accepted Answer · 2009-11-10 09:34:39Z

1

Try woking with UPDATE … FROM and an alias.

UPDATE 
  dbo.Network_People
SET 
  NGTimeStamp = warehouse.[TimeStamp]
FROM
  NextGen4.NGEPMWareHouse.dbo.Network_People AS warehouse
  INNER JOIN dbo.Network_People AS people ON people.HIN = warehouse.HIN

answered Nov 10, 2009 at 9:34

Tomalak

339k68 gold badges547 silver badges635 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

silent · Accepted Answer · 2009-11-10 09:37:17Z

1

Try to exclude ".dbo" prefix from your tablenames and use "update from"

edited Nov 10, 2009 at 9:37

answered Nov 10, 2009 at 9:31

silent

3,93327 silver badges30 bronze badges

Collectives™ on Stack Overflow

SQL Server Linked Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related