Chat now with support
Chat with Support

Benchmark Factory for Database 7.6 - User Guide

Getting Started Overview of Benchmark Factory Benchmark Factory Components Agents Connections Create and Edit Tests and Jobs Test Results and Run Reports Troubleshooting Licensing REST API

Creating a SQL 2000 Trace Table Using the SQL Server Profiler

To create a SQL 2000 trace table

  1. Initiate the SQL Profiler.
  2. Click the New Trace icon. The Connect to SQL Server window displays.
  3. Select the appropriate SQL Server from the drop-down list.
  4. Check the Start SQL Server if it is stopped check box.
  5. Select the appropriate Connection using radio button.  Enter the appropriate login name and password.
  6. Click OK. The Trace Properties window displays.
  7. Click the General tab.
  8. Enter a name for the trace in the Trace name field.
  9. Check the Save to table check box. The Destination Table window displays.
  10. Select the appropriate database from the Database drop-down list.
  11. Select the appropriate table from the Table drop-down list.
  12. Click OK. The Trace Properties window displays.
  13. Click the Events tab.
  14. Select TSQL from the Available events classes list.
  15. Click Add.
  16. Click the Data Columns tab.
  17. Add the following columns (minimum):
  • EventClass
  • Login Name
  • ClientProcessID
  • NTUserName
  • Duration
  • StartTime
  • TextData
  1. Click Run.
  2. Run SQL statements.
  3. When finished running SQL statements, click the Stop selected trace icon. The table is created.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating