Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
By default, MSSQL Auditor does not log SELECT statements from your monitored SQL Server. This article details how to modify the Auditor's trace definition file to accomplish that.
File > Templates > Import Template. Browse to C:\Program Files (x86)\SolarWinds Log and Event Manager MSSQL Auditor\tdfs and open the trace definition file that corresponds to your version of SQL Server.
File > Templates > Edit Templateand go to the Event Selection tab.
Show all eventscheckbox.
TSQL > BatchStarted, and click the Save button.
File > Templates > Export Templateand overwrite the existing trace definition file. (You may wish to simply rename the old file and save this new file with the same name as the old file.)
Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.