Package element: TraceLoadScript

CollapseAll image

Collapse image Properties


 Name   Value 
CreationName  
DataType String
Description  
EvaluateAsExpression True
Expression "SELECT {LF} [TextData], {LF} [BinaryData], {LF} [DatabaseID], {LF} [TransactionID], {LF} [LineNumber], {LF} [NTUserName], {LF} [NTDomainName], {LF} [HostName], {LF} [ClientProcessID], {LF} [ApplicationName], {LF} [LoginName], {LF} [SPID], {LF} [Duration], {LF} [StartTime], {LF} [EndTime], {LF} [Reads], {LF} [Writes], {LF} [CPU], {LF} [Permissions], {LF} [Severity], {LF} [EventSubClass], {LF} [ObjectID], {LF} [Success], {LF} [IndexID], {LF} [IntegerData], {LF} [ServerName], {LF} [EventClass], {LF} [ObjectType], {LF} [NestLevel], {LF} [State], {LF} [Error], {LF} [Mode], {LF} [Handle], {LF} [ObjectName], {LF} [DatabaseName], {LF} [FileName], {LF} [OwnerName], {LF} [RoleName], {LF} [TargetUserName], {LF} [DBUserName], {LF} [LoginSid], {LF} [TargetLoginName], {LF} [TargetLoginSid], {LF} [ColumnPermissions], {LF} [LinkedServerName], {LF} [ProviderName], {LF} [MethodName], {LF} [RowCounts], {LF} [RequestID], {LF} [XactSequence], {LF} [EventSequence], {LF} [BigintData1], {LF} [BigintData2], {LF} [GUID], {LF} [IntegerData2], {LF} [ObjectID2], {LF} [Type], {LF} [OwnerID], {LF} [ParentName], {LF} [IsSystem], {LF} [Offset], {LF} [SourceDatabaseID], {LF} [SqlHandle], {LF} [SessionLoginName], {LF} [PlanHandle]{LF}, [GroupID] FROM{LF} ::fn_trace_gettable(N'" + @[User::TraceCurrentFile] + "', 1){LF} WHERE{LF} [EventSequence] > " + @[User::TraceLastEventSequence]
IncludeInDebugDump False
Name TraceLoadScript
Namespace User
QualifiedName User::TraceLoadScript
RaiseChangedEvent False
ReadOnly False
SystemVariable False
Value SELECT {LF} [TextData], {LF} [BinaryData], {LF} [DatabaseID], {LF} [TransactionID], {LF} [LineNumber], {LF} [NTUserName], {LF} [NTDomainName], {LF} [HostName], {LF} [ClientProcessID], {LF} [ApplicationName], {LF} [LoginName], {LF} [SPID], {LF} [Duration], {LF} [StartTime], {LF} [EndTime], {LF} [Reads], {LF} [Writes], {LF} [CPU], {LF} [Permissions], {LF} [Severity], {LF} [EventSubClass], {LF} [ObjectID], {LF} [Success], {LF} [IndexID], {LF} [IntegerData], {LF} [ServerName], {LF} [EventClass], {LF} [ObjectType], {LF} [NestLevel], {LF} [State], {LF} [Error], {LF} [Mode], {LF} [Handle], {LF} [ObjectName], {LF} [DatabaseName], {LF} [FileName], {LF} [OwnerName], {LF} [RoleName], {LF} [TargetUserName], {LF} [DBUserName], {LF} [LoginSid], {LF} [TargetLoginName], {LF} [TargetLoginSid], {LF} [ColumnPermissions], {LF} [LinkedServerName], {LF} [ProviderName], {LF} [MethodName], {LF} [RowCounts], {LF} [RequestID], {LF} [XactSequence], {LF} [EventSequence], {LF} [BigintData1], {LF} [BigintData2], {LF} [GUID], {LF} [IntegerData2], {LF} [ObjectID2], {LF} [Type], {LF} [OwnerID], {LF} [ParentName], {LF} [IsSystem], {LF} [Offset], {LF} [SourceDatabaseID], {LF} [SqlHandle], {LF} [SessionLoginName], {LF} [PlanHandle]{LF}, [GroupID] FROM{LF} ::fn_trace_gettable(N'C:\Users\macies\AppData\Local\Temp\ecodedc\DC_Trace_MSSQL.1.f37780d4-fea7-4271-90b2-fa553ad4ca91.0_1.trc', 1){LF} WHERE{LF} [EventSequence] > 0
VariablePath \Package\For Loop Container\FEF - For each trace file - regular trace upload\DFT - Upload trace file.Variables[User::TraceLoadScript]

Collapse image See also


Package index