When a transaction truncate a global temporary table, is that logged in transaction log or error log? When a transaction truncate a global temporary table, is that logged in transaction log or error log ? I have inherited bunch of old SQL 2012 servers from my senior dbas who left the organisation. I'm stuck with queries from report users which processes are truncating certain business critical tables.
If it is logged in transaction log, then could the SID,login details be retrieved? Suspect, there are multiple agent job using those ##table.
You mean a ##temp table? It isn't logged in error log. But it must be logged in transaction log since you can rollback a truncate table command.