• when I run the script( as posted), error is returned:

    Msg 102, Level 15, State 1, Line 14

    Incorrect syntax near 'T'.

    this: select * from sys.traces

    returns: C:\Program Files\Microsoft SQL Server\MSSQL\log\log_77.trc

    I am a novice at Traces and profiler.

    what might be my error?