Hi all,

I want a trigger to get fired when my application's connection to the
database gets disconnected abnormally.

Currently I am able to find out using "sp_who", which servers are connected
to the database and their connection status.
However I need a trigger to be fired on the event when there is abnormal
disconnection.
I plan to monitor the Server Name and its status in the " sp_who "
procedure

Can someone tell me which table does "sp_who" query on?

Is there any other way to execute a stored procedure and perform some steps
when a connection is lost to a database?

Any comments/suggestions would be appreciated.

Thanks..
Sonali

Hi,

This is a newsgroup about Microsoft SQL Server, not Postgres.

If you're question is about Microsoft SQL Server, what is the version you
use (select @@vesion)?

Regards.
Jacques.

"Sonali Bhagat" <sonali.bhagat@edisphere.com> a écrit dans le message de
news: ewhj0IeCJHA.4724@TK2MSFTNGP05.phx.gbl...
> Hi all,
>
> I want a trigger to get fired when my application's connection to the
> database gets disconnected abnormally.
>
> Currently I am able to find out using "sp_who", which servers are
> connected to the database and their connection status.
> However I need a trigger to be fired on the event when there is abnormal
> disconnection.
> I plan to monitor the Server Name and its status in the " sp_who "
> procedure
>
> Can someone tell me which table does "sp_who" query on?
>
> Is there any other way to execute a stored procedure and perform some
> steps when a connection is lost to a database?
>
> Any comments/suggestions would be appreciated.
>
> Thanks..
> Sonali
>