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..

​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..   Read More

​