We can see the execution plan using sql server profiler.
See how to open the sql server profiler
Open the sql server profiler
Connecting to the sql server profiler
Once we click on connect below screen will be open.
Click on the Event select tab
Click on Show all events.
Expend performance
Select Show Plan XML
And click on run
Profiler window will be open
Now I am running sp in SSMS
See in profiler window.
Click on that row.
Execution plan will be shown.
