http://blogs.msdn.com/b/sqlqueryprocessing/archive/2006/10/17/showplan-trace-events.aspxBesides SSMS, another great tool available to database developers and DBAs to view query plans and troubleshoot query compilation or execution issues is the SQL Server Profiler. In the Profiler, all the showplan events are listed under the Performanceen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlqueryprocessing/archive/2006/10/17/showplan-trace-events.aspx#9764231Wed, 17 Jun 2009 04:54:51 GMT91d46819-8472-40ad-a661-2c78acb4018c:9764231 Tips Tricks and Advice from the SQL Server Query Processing Team | fix my credit<p>PingBack from <a rel="nofollow" target="_new" href="http://fixmycrediteasily.info/story.php?id=8451">http://fixmycrediteasily.info/story.php?id=8451</a></p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9764231" width="1" height="1">