1

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'.

Improve this question
2
  • I've found some samples here or here. Maybe this helps.
    – McNets
    Commented Feb 5, 2018 at 18:03
  • @McNets It looks like those examples are for SQL Server, using the same syntax as above that gives the error, unless I have missed something
    – Neil P
    Commented Feb 6, 2018 at 10:24

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.