We are facing a strange issue when XI executes a stored procedure in SQL server 2005. The underlying SQL statement generated by XI ( which we got tracing the xi sql call on the sql server ) when it executes the stored procedure contains a double quote on the timestamp parameter field - instead of a single quote for other datatypes .
This is causing a syntax error on the stored procedure call on the sql side - and this is not even seen by XI ( message is marked as successfull by XI in Adapter Engine ) . Anybody face this issue before ? Any resolutions ?