Page History

Versions Compared

...

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

Event	Trace (.trc)	Extended Events (.xel)	Audit Logs (.audit)
ApplicationName	Yes	Yes	No
ColumnPermissions	Yes	No	Yes
BeforeAfter	Yes	Yes	No
DatabaseID	Yes	Yes	Yes
DatabaseName	Yes	Yes	Yes
DBUserName	Yes	No	Yes
EventClass	Yes	Yes	Yes
EventSequence	Yes	-	Yes
EventSubClass	Yes	Yes	Yes
FileName	Yes	No	Yes
HostName	Yes	Yes	No
IsSystem	Yes	Yes	No
LinkedServerName	Yes	No	No
LoginName	Yes	Yes	Yes
NestLevel	Yes	Yes	Yes
ObjectID	Yes	No	Yes
ObjectName	Yes	No	Yes
ObjectType	Yes	No	Yes
OwnerName	Yes	No	No
ParentName	Yes	No	No
Permissions	Yes	No	Yes
ProviderName	Yes	No	No
RoleName	Yes	No	No
RowCounts	Yes	Yes	No
ServerName	Yes	Yes	Yes
SessionLoginName	Yes	Yes	Yes
SPID	Yes	Yes	Yes
StartTime	Yes	Yes	Yes
Success	Yes	No	Yes
TargetLoginName	Yes	No	Yes
TargetUserName	Yes	No	Yes
TextData	Yes	Yes	Yes

...