any way to trace why application loose conenction to sql server ?

[Alex]

Hi,
We have 3 -rd party application connected to one of our sql server 24 X 7
Once or twice a day application crashes
with application error (connection lost).

1.Is possible to trace application errors using SQL profiler ?
2. Create SQL alert or write to SQL log in case of falure for specific application ?
Thank you
Alex

[Ray Miao]

Trace is possible.


------------
Alex at 7/25/2002 12:07:47 PM

Hi,
We have 3 -rd party application connected to one of our sql server 24 X 7
Once or twice a day application crashes
with application error (connection lost).

1.Is possible to trace application errors using SQL profiler ?
2. Create SQL alert or write to SQL log in case of falure for specific application ?
Thank you
Alex

[Alex]

could you specify what Envent classes and datacolumns should be used to get this info.
I am using presently
1. Errors and Warning (Attention and Exeption)
2. Audit server(Audit server start and stops)
3. Sessions(Existing sessions)

Thank you
Alex



------------
Ray Miao at 7/26/2002 8:41:48 AM

Trace is possible.


------------
Alex at 7/25/2002 12:07:47 PM

Hi,
We have 3 -rd party application connected to one of our sql server 24 X 7
Once or twice a day application crashes
with application error (connection lost).

1.Is possible to trace application errors using SQL profiler ?
2. Create SQL alert or write to SQL log in case of falure for specific application ?
Thank you
Alex