SQL Profiler is only human interactive? Is it possible to run the
application through API? Will it send any notification when certain event
happens?

I am using SQL 2K.

Hanuman.

You can use the sp_trace_xxxxx stored procedures to create
and execute traces. You can create a trace in profiler and
save it to a trace file - that's the quickest way to get
started with it. You control the execution of the trace with
sp_trace_getstatus. You can find more information on the
tracing stored procedures in books online
Tracing is different from alerts. I can't think of any
direct way to modify a trace to have it send alerts.

-Sue

On Thu, 2 Jun 2005 14:56:02 -0700, "Hanuman Mishra"
<Mishra_Hanu***@rediffmail.com> wrote:

Show quoteHide quote

Same Random order every time
Trying to determine the correct database replication to use.
Data File size
3GB RAM in a server
Instalation of SP4 on MSDE RevA
Enterprise Manager connection to Local server very sloooow.
Error Addiing a PK Constraint
Server Performance Tunning
Waiting for type 0x4, current count 0x808, current owning EC 0x00000000.
Newbie Question - Edit data on SQL Server using Data access pages