I have a job which monitors the default trace file and alerts me to database creations/deletions/restores.
This works fine on most of our servers but on one it doesn't.
select * from sys.configurations where configuration_id = 1568
shows that the default trace is running but
select * from ::fn_trace_getinfo(0)
returns 0 records and there is no sign of a log.trc anywhere on the file system.
Does anyone know why the default trace would not be running or how to get it working?