Failed to save trace data to table - Profiler stops with this message

Question

I am trying to run profiler and get it to log to a database. The profiler starts to run and then after few hours (yes few hours, I know its bad!!) the profiler stops with the message.

Failed to save trace data to table

When I look at the logs, I can only find:

SQL Trace stopped. Trace ID = '2'. Login Name = 'sa'.

There are no other error messages. Any ideas why this might be happening?

Answer 1

If Network connection fails during this time, you might get "Failed to save trace data" or "Failed to read trace data" error messages.

Answer 2

If you have grouping defined, you will receive that error if you try to save to table. In "Trace properties" dialog, go to Events Selection->Organize Columns (button) and move everything from "Groups" section down to "Columns" section. Click OK, Run, and enjoy!