Timeline for Understanding DBCC TRACEON and TRACEOFF Globally and Session-wise
Current License: CC BY-SA 4.0
9 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Sep 18 at 8:46 | vote | accept | John K. N. | ||
May 10, 2021 at 19:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
Jan 1, 2021 at 8:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
Nov 20, 2020 at 6:08 | answer | added | sqL_handLe | timeline score: 3 | |
Sep 22, 2020 at 12:00 | history | tweeted | twitter.com/StackDBAs/status/1308375502873337857 | ||
Sep 21, 2020 at 13:36 | comment | added | Tibor Karaszi | Ah, I see. You want it on globally, but not for your own session? I don't think trace flags work that way. If it is on at any level, then it is on. Like OR logic, I guess. But I've leave it to somebody that has more insights to jump in here. | |
Sep 21, 2020 at 13:19 | comment | added | John K. N. | I was somehow expecting an answer along your lines. So I can't turn off the trace flag just for a/my session? I don't want to turn it off globally, just for the duration of my query. | |
Sep 21, 2020 at 13:13 | comment | added | Tibor Karaszi | I have a feeling that I'm stating the obvious here, but since I have some difficulties following the example, I'll mention just in case: If you turn on a traceflag globally (-1), you have to turn it off with -1 as well. | |
Sep 21, 2020 at 12:28 | history | asked | John K. N. | CC BY-SA 4.0 |