Script that trace SQL Server Database activities

[jason_clark]

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.?

[Kristen]

SQL Profiler?

[djj55]

@jason_clark

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.

[graz]

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.