November 22, 2016 at 10:50 am
Is there any difference in enabling trace flag using DBCC TRACEON globally using -1 and enabling trace flag as startup parameter using -T?
November 22, 2016 at 11:13 am
DBCC TRACEON would need to be manually re-run after a server restart. If you use the startup parameters of the service then it will automatically have that flag set every time. The functionality would be the same though.
November 22, 2016 at 11:19 pm
Chris Harshman (11/22/2016)
DBCC TRACEON would need to be manually re-run after a server restart. If you use the startup parameters of the service then it will automatically have that flag set every time. The functionality would be the same though.
Thanks Chris. I had this in mind and tested the same but i forgot that i have added then as startup so even after restarted i found the trace flags still there.:-D:-D:-D:-P
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply