sys.fn_xe_file_target_read_file (Transact-SQL)
Reads files that are created by the Extended Events asynchronous file target. One event, in XML format, is returned per row.
![]() |
---|
SQL Server 2008and SQL Server 2008 R2 accepts trace results generated in XEL and XEM format. SQL Server 2012 Extended Events only supports trace results in XEL format. We recommend that you use SQL Server Management Studio to read trace results in XEL format. |
Column name |
Data type |
Description |
---|---|---|
module_guid |
uniqueidentifier |
The event module GUID. Is not nullable. |
package_guid |
uniqueidentifier |
The event package GUID. Is not nullable. |
object_name |
nvarchar(256) |
The name of the event. Is not nullable. |
event_data |
nvarchar(max) |
The event contents, in XML format. Is not nullable. |
file_name |
nvarchar(260) |
The name of the file that contains the event. Is not nullable. |
file_offset |
bigint |
The offset of the block in the file that contains the event. Is not nullable. |