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?