SQL Trace is one of my favorite SQL Server features. Tracing in SQL server allows one to selectively capture and record valuable details of SQL Server Database Engine events that would otherwise be discarded. Information captured with these events is useful for a variety of purposes, such as performance analysis, troubleshooting, forensics, establishing baselines and proactively identifying problem areas.
Read more
http://www.sqlservercentral.com/articles/SQL+Trace/71693/
cheers
samitha
Read more
http://www.sqlservercentral.com/articles/SQL+Trace/71693/
cheers
samitha