question

Hi, we have recently had a system upgrade and move the accompanying database from 2008 R2 (10.50.4000) to 2012 (11.0.3000). One of the system admins created a linked server from the old server to the new one and then ran a TSQL query against 2 tables in the new database. This query always returns the correct results but on its first execution it also returns an error: > Msg 105, Level 15, State 1, Line 1 > Unclosed quotation mark after the character string '{d174b015-8602-e411-'. > Msg 102, Level 15, State 1, Line 1 > Incorrect syntax near '{d174b015-8602-e411-'. - Subsequent executions return the same results but with no error. - If the query is edited and executed against only one table there is no error. - If the whole query is executed from the 2012 server then there is never an error - There is no value in the data of the joined columns that is close to the value in error (yes, the join is on a GUID column. I cant help that, its a 3rd party system). The query is : SELECT TOP(11) usr.Company from [LinkedServer].database.dbo.user usr left join [LinkedServer].database.dbo.common com on com.[ID] = usr.[ID] - Changing the TOP number results in the error for the first execution but for no subsequent ones. - Removing the TOP has the same effect as prev point. - Changing to an inner join has the same effect. - Creating a linked server on from 2012 doesn't have any such issues. Has anyone seen this issue and/or identified how to avoid it?