Has anyone setup alert forwarding with any success in sql 2000? I have
configured a master and target server but can't seem to get beyond that.
And I am having great problems find any documentation on alerts

I want to setup alert forwarding to harness the sqlmail functioning on
the master server. Is this a possibility. When the alerts fires on a
target server, I want the master server to be notified and send out an
email. When you are setting up alert forwarding, do you set up the alert
locally? Or on the master server? I can't seem to find any answers to
I am running sql 2000 and win 2000.