How can I see the execution plan for stored procedures and triggers in SQL Server?

Question

How can I see the execution plan for stored procedures and triggers in SQL Server?

Answer 1

Yes, you can using SQL Profiler. See Using SQL Server Profiler

Answer 2

Assuming you're using MSSQL, yes, see here

Answer 3

you can do

set showplan_text on

or hit CTRL + K and it will be included as a separate tab next to query results