i have figured it out

the query is using a stored procedure. i checked the conent of the sp on the destination server...