Sample Header Ad - 728x90

Automatically enable trace flag after server restart

0 votes
2 answers
1961 views
We would like to permanently enable a trace flag on a server. I know that it is an option to add start-up parameters in SQL Server Configuration Manager. Is there any option to do it automatically after server restart via procedure/function/other solutions? We would like to give visibility of trace flags (and options for enable/disable) to a team that will not have access to SQL Server Configuration Manager and does not have sysadmin level permissions. We were thinking about a job executed as a sysadmin group user after server restart (not sure If it is possible) . Job could have a step executing a procedure with code such as DBCC TRACEON (7412) etc.
Asked by adam.g (465 rep)
Feb 22, 2022, 12:05 PM
Last activity: Feb 23, 2022, 06:59 AM