what is the procedure in SQL server to not execute anything(T SQL commands) but outputs the commands it would execute

Question

gbn · Accepted Answer · 2011-04-12 09:29:16Z

2

There isn't one unless you are using dynamic SQL where you'd use PRINT

You can see a stored proc definition but this won't show you any actual parameter values etc

answered Apr 12, 2011 at 9:29

gbn

434k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martin Smith · Accepted Answer · 2011-04-12 13:00:05Z

1

Are you thinking of SET SHOWPLAN_TEXT ON?

answered Apr 12, 2011 at 13:00

Martin Smith

457k97 gold badges777 silver badges887 bronze badges