Link to home
Start Free TrialLog in
Avatar of tommym121
tommym121Flag for Canada

asked on

SQL - using remote database value scaled functions

I have a local database say 'local' and remote database called  'remote' on 'RemoteMachine'

I am trying to run a SQL statement on the SSMS like

use local;

select RemoteMachine.remote.dbo.valueScaledFunction (a.field1) from local a

I got an error saying

cannot find either column "remote" or the user-defined function or aggregate "dbo.valueScaledFunction", or the name is ambiguous.
SOLUTION
Avatar of lcohan
lcohan
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 tommym121

ASKER

Thanks