Categories
Database Development

How to Get All Server Side Traces in SqlServer from SSMS, stop it from SSMS and delete the log files

How to Get All Server Side Traces in SqlServer from SSMS(Active,Inactive), stop it from SSMS and delete the log files.
I need all traces saving into file as well as table.

I tried SELECT * FROM fn_trace_getinfo(DEFAULT). Some times few parameters are NULL. What does it mean ?

Leave a Reply

Your email address will not be published. Required fields are marked *