Unfortunately, doing anything on the linked server is out of the question..as a matter of policy.

I've tried the SQL Server OPENQUERY function, but it only works with SELECT...