Forum Discussion

GabiSarbu's avatar
GabiSarbu
Copper Contributor
Sep 17, 2024

SQL Server audit logs incorrect info on column object_name

Hi, during an audit check on database events, i have noticed that sometimes on DDL events, when temp tables are mentioned, sql server 2017 logs incorrect information on columns schema_name and  object_name and the statement column proves this:

 

Moreover, on the two columns the info for the object on which the DDL was applied, is taken randomly, it may show the first table, or the second, making this difficult to prove the actions in case of audits:

Sadly, i haven't found this reported anywhere..

 

No RepliesBe the first to reply

Resources