Hi I am trying to set up an alert for error#1205.
I have 2 different servers A and B of same configuration
sql server 2000 with sp-3a(8.00.760)
on windows 2003 enterprise version.
server-A is without cluster and
Server-B is with cluster.
I set trace falgs 1204,1205,3604,3605 globally on both servers
but on my server-A I am getting an email alert when deadlock ouccurs
and on Server-B(I apply same method to configure alert) I am not getting an email alert
my SQL mails are working fine on server-B.
Also I have created a job on server-B but that is also not getting invoked
after deadlock occurs.But I can see in errorlogs that deadlock occured.
Is there anything special for cluster?Please let me know where to look now?
Thanks