Options
Turning OFF Deadlock Traceflag
johnnywyskiel
Posts: 4 Bronze 1
Is there a way to configure RedGate NOT to turn on the Deadlock traceflag? Accorting to the logs, SQL Monitor is turning on Traceflag 1222 even if I turn it off.
Background:
One of the database contains ePHI data and since flag 1222 will output the queries of the deadlocked sessions, it's possible that the deadlock output into the error log could have sensitive data. Per our auditor, we should turn off that output into the SQL Server error log.
Background:
One of the database contains ePHI data and since flag 1222 will output the queries of the deadlocked sessions, it's possible that the deadlock output into the error log could have sensitive data. Per our auditor, we should turn off that output into the SQL Server error log.
Comments
Thanks for posting on the Redgate forums.
There isn't a method for setting this within the SQL Monitor UI, however, it should be achievable by editing the user SQL Monitor uses to log in to SQL.
If you remove sysadmin privileges from the user this deny him the right to turn on the Trace 1222 flag. You would then need to apply the rest of the permissions on this page to ensure SQL monitor continues to function correctly. Please let me know if you need any further assistance with this.
http://documentation.red-gate.com/displ ... ermissions
Dan Bainbridge
Product Support Engineer | Redgate Software