Remote function calls

• TheRedneckDBA

  SSChampion

  Points: 14001

  More actions

  August 19, 2008 at 11:29 am

  #154638

  I get the following error when I execute the SQL below:

  Msg 4122, Level 16, State 1, Line 51

  Remote table-valued function calls are not allowed.

  SELECT * FROM [SERVERNAME].DBNAME.dbo.fn_ProducerVarianceReport (NULL, NULL, @BeginAcceptanceDate, @EndAcceptanceDate)

  ----

  Is there a setting to get arround this, or is it an intentional limitation built in to SQL 2005?

  The Redneck DBA

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  August 19, 2008 at 11:36 am

  #860185

  Its a limitation built in to linked server functionality.

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot