while executing a MDX through the Linked Server on a 64 bit SQL server 2005 it's throwing Error 7320: Cannot execute the Query "With Set....".
This error doesn't occur frequently.. Once or twice in a week it does happen... The Profiler states the Operation has been cancelled... with error -1055129598.... Not much expalnation is available in microsoft KB ...
I don't think this Error would be because of system out of memory exception... since the server is having huge amount of free memory...
SQl server 2005 64 bit enterprise edition, with 32 GB Ram ...
Any Soultion \ ideas?