Views:
  1. Run the MS SQL Server Management Studio.

  2. Go to Tools > SQL Server Profiler.

    Navigating to SQL Server Profiler

  3. Provide a name under Trace name.
  4. Use the “Standard (default)” template.
  5. Click Save to File.
  6. Provide the path and filename for the file to be saved.
  7. Adjust the Set maximum file size (MB) accordingly.
  8. Retain the default Enable file rollover.

  9. Click Run to start the trace.

    Configuring trace properties

  10. Replicate the issue on hand. Once completed, press the Stop button (red button).

  11. Submit the trace file to Trend Micro Technical Support.

    Trace file sample

     

 
Install the SQL Server Management Tools if SQL Server Profiler is not present under the Tools option.
 

For more information, refer to this Microsoft KB article: Install SQL Server Management Tools.

Keywords: create trace file via ms sql profiler,trace file creation using profiler,server management tool