I have a SPROC that takes in parameters and uses OpenQuery to create a record in an AS400 DB2 table. It works fine from my development server ( MS/SQL 2008 R2 ) but not from my production server ( MS/SQL 2008 R2 ). The Linked Server to the AS400 is identical on both servers. My production server returns this error:
A syntax error was detected at token .. Token . is not a valid token.