vinodv.viswanathan
Old Hand
Points: 309
More actions
March 12, 2013 at 5:00 am
#271382
Is there any workaround for the 8000 character limitation in the openquery for executing MDX queries?
is there any other option other than to split the query to execute it multiple times..............:-)
Orlando Colamatteo
SSC Guru
Points: 182276
March 12, 2013 at 6:58 am
#1595969
EXEC() AT inked_server might be an option.
You can also adapt Example G to pass a variable containing your SQL of type N/VARCHAR(MAX) to EXEC(): http://msdn.microsoft.com/en-us/library/ms188332(v=sql.105).aspx
There are no special teachers of virtue, because virtue is taught by the whole community.--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply