Using fmtonly

A similar behavior can be obtained for capturing plans in stored procedures without actually executing the stored procedures, using fmtonly set.

sp_add_qpgroup pubs_dev
go
set plan dump pubs_dev on
go
set fmtonly on
go
exec stored_proc(...)
go