August 14, 2003 at 9:07 am
Bit of a weird one.
If I run any query FOR XML ... in QA, with Show Execution Plan, I get no results and the error message:
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
Take execution plan off and it works fine.
I noticed this for the first time shortly after installing of MSXML 4 SP2+SDK, but I don't know if this is related, my hunch is not.
It's not a problem, but I wondered if anyone else had seen the same thing?
August 18, 2003 at 12:00 pm
This was removed by the editor as SPAM
August 19, 2003 at 5:10 pm
Have not. Installed XML on both server and locally?
Andy
August 20, 2003 at 4:02 am
>>Installed XML on both server and locally?
Not exactly sure what's installed on the server(s) in terms of XML, but I get exactly the same results when I connect to the local SQL Server instance, as when I connect to a remote server.
To reproduce it, I just need to run
SELECT 1 example FOR XML RAW
from query analyser. Works when we don't show the execution plan, and fails (to return a resultset) when we do show the plan. However, the execution plan is actually shown and looks valid.
The setup across all servers I've tried this on is broadly, W2K SP4, SQL2k SP3.
I'll try it again from a different client machine and see what happens.
April 12, 2005 at 10:05 pm
I always have the "Unknown token received from SQL Server" error when graphic execution plan is turned on and i have any FOR XML clause
It seems that the correct results are still returned if it is a simple query (SELECT * FROM tablename) before the error is returned. Any query with a join does not return anything.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply