Actually, you can, you just have to set up the link server correctly. But since it is a procedure, you need to execute it as such (taking your sql statement and what looks like your link server).  Note the two single quotes around each parameter.SELE...