I have run a [server side profile trace][1] for over an hour to produce a .trc file with all activities in one of my databases. I have then passed this .trc trace file as a parameter to the database engine tuning advisor. [![enter image description here][2]][2] After running the DTA I get the recommendations: [![enter image description here][3]][3] How do I script out the recommendations? I am using sql server 2005, I don't seem to find any other way than scripting them individually which is overly time consuming. [1]: https://msdn.microsoft.com/en-us/library/cc293613.aspx [2]: https://i.sstatic.net/IAWYU.png [3]: https://i.sstatic.net/Tad0H.png