Probably a quick question.
We are looking to test out a couple trace flags as startup parameters in our environment, and while I know we can use
DBCC TRACESTATUS to get global-scoped trace flags, it doesn't specify whether this was set at startup or merely set with the -1 flag. Is parsing the SQL error log the only method available? Possibly a registry entry somewhere?
Any way this can be tackled programmatically would be useful.
Thanks for reading!