Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

UDF over linked server?

Status
Not open for further replies.

bjd4jc

Programmer
Nov 8, 2001
1,627
0
0
US
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
 
select * from openquery(DOTNET,'select northwind.dbo.xyz(100)')
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top