Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Database Engine
Operations
Monitoring
Monitoring Events
Replaying Traces
 Considerations for Replaying Traces
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
Other versions are also available for the following:
SQL Server 2008 Books Online (October 2009)
Considerations for Replaying Traces

SQL Server Profiler cannot replay the following kinds of traces:

  • Traces that contain transactional replication and other transaction log activity. These events are skipped. Other types of replication do not mark the transaction log so they are not affected.
  • Traces that contain operations that involve globally unique identifiers (GUID). These events will be skipped.
  • Traces that contain operations on text, ntext, and image columns involving the bcp utility, the BULK INSERT, READTEXT, WRITETEXT, and UPDATETEXT statements, and full-text operations. These events are skipped.
  • Traces that contain session binding: sp_getbindtoken and sp_bindsession system stored procedures. These events are skipped.
  • SQL Server Profiler does not support replaying traces collected by Microsoft SQL Server version 7.0 or earlier.
ms188238.note(en-us,SQL.100).gifNote:
In SQL Server 2005 or later, if you do not use the preconfigured replay template (TSQL_Replay), and do not capture all required data, SQL Server Profiler does not replay the trace. For more information, see Replay Requirements.

For information about what permissions are required to replay a trace, see Permissions Required to Run SQL Server Profiler.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement | Site Feedback
Page view tracker