There is nothing built into mojoPortal for logging sql activity. There are tools for most database platforms that can do this, for MS SQL there is SQL Profiler but this tool is not included in the free Express versions of MS SQL.

Hope it helps,

Joe

For the MS SQL data layer I will add logging in the Execute* methods of SQLParamterHelper like this:

if (log.IsDebugEnabled) { log.Debug("ExecuteReader " + commandText); }

so one could enable this logging by setting the log level in the log4net.config to DEBUG and it will log the command text which is only going to be the stored procedure name.