Is it possible to execute a User defined function across a linked server? I have a linked server called DEVFS and a database called KnzFSData and a udf called KLMS_GetLowestComponent. Here is how I am calling it (test only):
PRINT DEVFS.KnzFSData.dbo.KLMS_GetLowestComponent(paramlist)
I get the following error:
The object name 'DEVFS.KnzFSData.dbo.' contains more than the maximum number of prefixes. The maximum is 2.
I have no problem executing stored procs or selecting from views or tables. Is this possible?
Thanks
Brian
PRINT DEVFS.KnzFSData.dbo.KLMS_GetLowestComponent(paramlist)
I get the following error:
The object name 'DEVFS.KnzFSData.dbo.' contains more than the maximum number of prefixes. The maximum is 2.
I have no problem executing stored procs or selecting from views or tables. Is this possible?
Thanks
Brian