Link to home
Start Free TrialLog in
Avatar of notcjw
notcjw

asked on

Updating Local MSSQL server from Linked MSSQL server

Trying to update ao  Local Server Database from a Linked Database and keep getting multi-part identifier errors.
MSSQL Servers
Local Server: SQL3
Linked: ILL-SSQL

USE sagedata
Update [SQL3].sagedata.dbo.transactions
Set [SQL3].sagedata.dbo.transactions.illnumber = [ILL-SQL].sagedata.dbo.transactions.illnumber
FROM [ILL-SQL].sagedata.dbo.transactions
INNER JOIN ILL-SQL ON [SQL3].sagedata.dbo.transactions.transactionnumber = [ILL-SQL].sagedata.dbo.transactions.transactionnumber
Go
SOLUTION
Avatar of John_Vidmar
John_Vidmar
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of notcjw
notcjw

ASKER

Thank you.