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
Last activity: Feb 23, 2022, 06:59 AM