I am querying a remote server for which I only have read permissions. I set up a local server with a UDF (since I cannot create one on the remote) that I would like to utilize for the query. When I try executing the query, I receive the error
Msg 344, Level 16, State 1
Remote function reference 'localhost\SQLDEV.db.dbo.udf_StripHTML' is not allowed, and the column name 'localhost\SQLDEV' could not be found or is ambiguous.
I tried looking for solutions, but nothing seemed remotely (haha) close to my situation as all other solutions were for executing a remote function against a local query, or trying to pass variables with OPENQUERY, etc. Is there a simple way to achieve this query with only read access to the remote, master db?
SELECT [localhost\SQLDEV].[db].[dbo].[udf_StripHTML](notes.note_text) FROM event_log AS el INNER JOIN dbo.progress_note as notes on notes.event_log_id = el.event_log_id