Versions Compared

Old Version 15

changes.mady.by.user Unknown User (6092af18a56f2f006f392eb0)

Saved on

compared with

New Version 16

changes.mady.by.user Nicolas Rios

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

EventTrace Events (.trc)Extended Events (.xel)Audit Logs (.audit)
ApplicationName

Available

AvailableUnavailable
ColumnPermissionsAvailableUnavailableAvailable
BeforeAfterAvailableAvailableUnavailable
DatabaseIDAvailableAvailableAvailable
DatabaseNameAvailableAvailableAvailable
DBUserNameAvailableUnavailableAvailable
EventClassAvailableAvailableAvailable
EventSequenceAvailable-Available
EventSubClassAvailableAvailableAvailable
FileNameAvailableUnavailableAvailable
HostNameAvailableAvailableUnavailable
IsSystemAvailableAvailableUnavailable
LinkedServerNameAvailableUnavailableUnavailable
LoginNameAvailableAvailableAvailable
NestLevelAvailableAvailableAvailable
ObjectIDAvailableUnavailableAvailable
ObjectNameAvailableUnavailableAvailable
ObjectTypeAvailableUnavailableAvailable
OwnerNameAvailableUnavailableUnavailable
ParentNameAvailableUnavailableUnavailable
PermissionsAvailableUnavailableAvailable
ProviderNameAvailableUnavailableUnavailable
RoleNameAvailableUnavailableUnavailable
RowCountsAvailableAvailableUnavailable
ServerNameAvailableAvailableAvailable
SessionLoginNameAvailableAvailableAvailable
SPIDAvailableAvailableAvailable
StartTimeAvailableAvailableAvailable
SuccessAvailableUnavailableAvailable
TargetLoginNameAvailableUnavailableAvailable
TargetUserNameAvailableUnavailableAvailable
TextDataAvailableAvailableAvailable
Note
titleExtended Events captures extra Execute events

Due to differences in how Microsoft has implemented Extended Events compared to other auditing methods, when auditing via Extended Events the user will see extra Execute events as compared to the same data captured by other auditing methods.

Note
titleNOTE
  • The Extended Events auditing feature is only available with SQL Server 2012 and newer. 
  • The Audit Logs auditing feature is only available with SQL Server 2017 and newer.

...