February 21, 2007 at 8:44 am
Title says it all. In my MASTER database(sql 2000) I can find sp_trace_getdate. According BOL there are sp_trace_setstatus, _create, _generateevent, _setevent and _setfilter. Can't find them in MSDB neither. Where are these sp'S?
Greetz,
Hans Brouwer
February 21, 2007 at 4:35 pm
Look in Programability\Extended Stored Procedures\System Extended Stored Procedures.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 21, 2007 at 4:37 pm
Oops, I didn't notice that you did specify SQL 2000... Still, look under the extended stored procs.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 23, 2007 at 12:43 am
Tnx for the info, found them indeed. Starnge though, that sp_trace_getdata is simply under the Stored Procedures...
But never mind that, tnx again.
Greetz,
Hans Brouwer
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply