Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Alerts for SQL locks

Author  Topic 

jocampo
Starting Member

48 Posts

Posted - 2006-07-19 : 10:34:56
Hello forum friends.

I'm having a lot of problems with locks and timeouts with a 2 nodes cluster. I think this is a DB design issue, but i would like to monitor locks when they appears anyway (to send and collect data for my own records). Do i have a way to do this? I mean, an Alert Trigger or something like that "shoot" an email when it appears? ...

Thanks in advanced,

PS: i already have an Exchange server and SQL operators running ok. So, i just need to find out this option ...
   

- Advertisement -