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.transa ctions
Set [SQL3].sagedata.dbo.transa ctions.ill number = [ILL-SQL].sagedata.dbo.tra nsactions. illnumber
FROM [ILL-SQL].sagedata.dbo.tra nsactions
INNER JOIN ILL-SQL ON [SQL3].sagedata.dbo.transa ctions.tra nsactionnu mber = [ILL-SQL].sagedata.dbo.tra nsactions. transactio nnumber
Go
MSSQL Servers
Local Server: SQL3
Linked: ILL-SSQL
USE sagedata
Update [SQL3].sagedata.dbo.transa
Set [SQL3].sagedata.dbo.transa
FROM [ILL-SQL].sagedata.dbo.tra
INNER JOIN ILL-SQL ON [SQL3].sagedata.dbo.transa
Go
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER