Versions Compared

Key

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

...

SQL Compliance Manager allows you to capture the following types of event data depending on your auditing selection.


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

Yes

YesNo
ColumnPermissionsYesNoYes
BeforeAfterYesYesNo
DatabaseIDYesYesYes
DatabaseNameYesYesYes
DBUserNameYesNoYes
EventClassYesYesYes
EventSequenceYes-Yes
EventSubClassYesYesYes
FileNameYesNoYes
HostNameYesYesNo
IsSystemYesYesNo
LinkedServerNameYesNoNo
LoginNameYesYesYes
NestLevelYesYesYes
ObjectIDYesNoYes
ObjectNameYesNoYes
ObjectTypeYesNoYes
OwnerNameYesNoNo
ParentNameYesNoNo
PermissionsYesNoYes
ProviderNameYesNoNo
RoleNameYesNoNo
RowCountsYesYesNo
ServerNameYesYesYes
SessionLoginNameYesYesYes
SPIDYesYesYes
StartTimeYesYesYes
SuccessYesNoYes
TargetLoginNameYesNoYes
TargetUserNameYesNoYes
TextDataYesYesYes


SQL Compliance Manager Calculated Columns
You can capture different event data by using the different auditing options

...