How to run the traces for the database in SQL server, is there any script for that ? Also, I want to trace every single activity of my database.?
If there is much activity this will produce LARGE amounts of data. Be prepared for that.
See if this might work for you: https://github.com/billgraziano/sql-scripts/blob/master/sp_ClearTrace.sql
I wrote to capture all SQL activity to feed ClearTrace.