December 17, 2002 at 9:21 am
Hello all,
I'd like to write an app in either C# or VB which can capture certain events on a SQL Server. Just like profiler, it would listen to the SQL Server constantly and would probably run in the system tray.
Could you point me in the right direction? How does profiler achieve this, are there any existing ActiveX controls for this or does the .NET framework include something suitable.
Thanks
Tom
December 17, 2002 at 2:06 pm
You might want to put a wrapper on SQL's stored procedures that Profiler uses. You can find them in BOL for System Procedures...
sp_trace_create
sp_trace_setfilter
sp_trace_generateevent
sp_trace_setstatus
sp_trace_setevent
Gary Johnson
DBA
Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply