December 22, 2008 at 12:20 am
Hi All,
I've search the Forum and read the Microsoft pages, but I can't seem to work out how to issue the "DBCC TRACEON", "DBCCTRACE OFF", and "DBCC TRACESTATUS" commands (I need to set 1807 from inside a DMO app).
Thanks in advance
matt
December 22, 2008 at 7:49 am
Do you wantr to just turn a trace on & off, or do it need to receive the stream also?
If the first, then you can just issue the commands through an ExecuteNonQuery(..) call.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 31, 2008 at 9:41 pm
December 31, 2008 at 9:52 pm
Glad I could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply