>Set up a trace (programmatically).
What do you mean?
>Also, you will be able to get execution plans between server restarts using DMV, see last query in
>
>
http://technet.microsoft.com/en-us/library/ms189747.aspx>
>(or google on the topic)
I need a server restart to get the execution plan?