Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Calling a function from a linked Server

Author  Topic 

kusumjain
Starting Member

21 Posts

Posted - 2009-10-21 : 10:53:14
What is the syntax to use a function on a linked server.


I get an error
Invalid column name '<ServerName>'. when i use
<Servername>.<databaseName>.dbo.<functionName()>

Any ideas.

Thanks,
Kusum Jain

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-10-21 : 11:42:38
i dont think you can call udf from linked server

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=485517
Go to Top of Page

kusumjain
Starting Member

21 Posts

Posted - 2009-10-22 : 13:43:20
Thank You
Go to Top of Page
   

- Advertisement -