Sample Header Ad - 728x90

Output result of DBCC PDW_SHOWEXECUTIONPLAN into a variable

1 vote
0 answers
315 views
I would like to output the results of DBCC PDW_SHOWEXECUTIONPLAN into a variable (or table, I'm not fussy!). I know the PDW syntax is quite different when it comes to outputing results, which means everything I've tried has so far failed. I've seen some suggestions of inserting the results into a table, but I always get syntax errors create table #1234 ( sql1 varchar(max) ) with (distribution = round_robin) insert into #1234 DBCC PDW_SHOWEXECUTIONPLAN(@did, @spid) >Parse error at line: 37, column: 2: Incorrect syntax near 'DBCC'.
Asked by Neil P (1294 rep)
Feb 5, 2018, 04:45 PM
Last activity: Feb 5, 2018, 05:58 PM