Package element: TraceLoadScript
Properties
| Name | Value |
| CreationName | |
| DataType | String |
| Description | |
| EvaluateAsExpression | True |
| Expression | "DECLARE @trace_file_name nvarchar(512){LF}SELECT @trace_file_name = path FROM sys.traces WHERE is_default=1{LF}{LF}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(@trace_file_name, default){LF} WHERE{LF} [EventSequence] > " + @[User::TraceLastEventSequence] |
| IncludeInDebugDump | False |
| Name | TraceLoadScript |
| Namespace | User |
| QualifiedName | User::TraceLoadScript |
| RaiseChangedEvent | False |
| ReadOnly | False |
| SystemVariable | False |
| Value | DECLARE @trace_file_name nvarchar(512){LF}SELECT @trace_file_name = path FROM sys.traces WHERE is_default=1{LF}{LF}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(@trace_file_name, default){LF} WHERE{LF} [EventSequence] > 0 |
| VariablePath | \Package\SEQ - Default trace upload\DFT - Upload default trace file.Variables[User::TraceLoadScript] |
See also