Hello can I create a trigger the records user, Database, TranType, commandExec
User= User that is executing command
Database= the database where this command is being executed
TranType = Type of command (Select,Update, Delete, Create, Drop, Alter, Truncate)
commandExec = The actual command that is being executed.
I like to get this data so i can insert to a table to keep a log.