Execute StoreProcedue in SQL2000 every time i received a replay me

Hi,
how can i execute a StoreProcedue in SQL2000 every time i received a replay
message with a specific subject, and pass some arguments like the subject.
thank in advanced,
Renato Ribeiro
Hi,
1. Create a Task to execute stored procedure
2. Create a message (SP_ADDMESSAGE) to create the subject
3. Using the message ID and Task name create a alert using SP_ADDALERT
4. Trigger the message using RAISERROR statement.
This will automatically fire the Task to execute the stored procedure
Thanks
Hari
SQL Server MVP
"Renato Ribeiro" <RenatoRibeiro@.discussions.microsoft.com> wrote in message
news:FA8C6A92-CB30-46B1-A9B8-187F43927B4D@.microsoft.com...
> Hi,
> how can i execute a StoreProcedue in SQL2000 every time i received a
> replay
> message with a specific subject, and pass some arguments like the subject.
>
> thank in advanced,
> Renato Ribeiro
>