I believe logging should happen outside the database. There are MANY logging systems available today like SeriLog (Thanks @John_Mitchell) . It reduces your database size and reduces the ability to tamper with the logs. Also, data logging is one thing but application logging (who ran what, when, where; are there errors I’m missing?), DMT, changes to settings or the application…
Log your votes.