title: How can I call Scalar user defined function from linked server?
body: <p>I have to run a query from linked server (SQL Server 2008) that contains Scalar UDF (with one parameter) on that server, when I run the query I got following error</p>
  
  <pre><code>Cannot find either column "PSW_Local" or the user-defined function or aggregate "PSW_Local.dbo.udf_psw_local_format_name", or the name is ambiguous.
  </code></pre>
  
  <p>I followed someones suggestion on the internet using <code>OPEN Query</code> but it's not working.</p>
  
  <p>Can anybody suggest different method?
  Thanks in advance </p>